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
How many types of sessions are there in informatica.please explain them?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Performance tuning in UNIX for informatica mappings?
What are the types of data warehouses?
What do mean by local and global repository?
Write the unconnected lookup syntax?
What will be the approach?
What is source qualifier transformation in informatica?
How to create the source and target database connections in server manager?
What is data transformation manager process?
What is Index Caches size?
What do you mean by blocking transformation?
Why union transformation is an active transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).