Gender Analysis in SSIS/SQL using name

Question

Post reply

Gender Analysis in SSIS/SQL using name

rhythmk

SSCertifiable

Points: 7271
More actions
June 28, 2017 at 2:52 am

#324247

we have to migrate the ETL code from DataFlux tool to SSIS tool.
In DataFlux, they have used a specific component (Gender Analysis) to generate a new field called "Gender" with the help of Customer's name & title (which is not a mandatory field) fields and we need to replicate the same functionality in SSIS or T-SQL logics (or algorithm).
Please let me know, if you faced this kind of scenario and the workaround for the same.
--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Tim Mitchell SSCoach Points: 15685 More actions · Answer 1

SSIS does not have gender analysis, but Melissa Data makes data quality and cleansing tools for SSIS that can do this.

Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 2

I'm not sure there's a good why to figure out gender based on first name and title. There are a lot of names that are used for both binary genders and then you have to worry about people who don't identify as a gender. I'm surprised there's actually a tool out there where people claim they can do that...

But no, SSIS doesn't have that capability. It has to be built.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 3

Heh... I think it's downright ridiculous anymore to even save an indication of gender.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 4

Agreed. Unless somebody specifically selects a gender designation form they've filled in, it's hugely, hugely problematic to "assign" one on the basis of a finger in the air calculation.