following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
Answer Posted / moorthy g
Source-SQ-Exp-Rtr-Tgt(twice)
Exp:
Flag: DECODE(True, gender='MALE', 'Y','N')
RTR:
Make It Two Group
Flag value is Y then Male is one group.
Defaull is Female
Tgt:
Make It Two;
male - Tgt1
female - Tgt2
=================
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is meant by LDAP users?
What is the fact table?
What are the types of lookup transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Mention some types of transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is the size of your data warehousing?
What is the cumulative sum and moving sum?
Explain the tuning lookup transformation - informatica
In development project what is the process to follow for an etl developer from day1
What are the components of Informatica? And what is the purpose of each?
What is mapplet in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.