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?
- 8 Answers
- 10435 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
Answer Posted / voma
use router transformation, In that 2 groups
1 is male, 2 is female,
target is single, but we drag the table twice
In that router 1st group condition
select * from table where gender='male'
2nd group condition
select * from table where gender='female'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
where to store informatica rejected data?
What are roles and groups and benefits of using them?
Briefly define a session task?
Enlist some properties of sessions.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is rank index in rank transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a filter transformation and why it is an active one?
What are the main issues while working with flat files as source and as targets ?
What is blocking transformation?
How to extract sap data using informatica? What is abap? What are idocs?
What do mean by local and global repository?
What is session task and command task?
How can we improve session performance in aggregator transformation?
Briefly define reusable transformation?
