In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male

in my output i need
male,female
vasu,geetha
ram,suma
kesav

Answer Posted / sakthi

1.sq1 (query override gender='m') -> exp1 ,seq1 gen nextval to exp1

2.sq2 (query override gender='f') -> exp2 ,seq2 gen nextval to exp2

3. connnect o/p exp1 to exp2 to joiner
* condition nextvalue =nextvalue
* condition type full outer join

4. connect name from exp1 & name from exp2 to target

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is union transformation in informatica?

676


What are the restrictions of union transformation?

552


What is olap (on-line analytical processing?

609


How to call shell scripts from informatica?

548


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1105






What are the different options available for update strategy?

552


What are the different clients of powercenter?

570


What is Cognos script editor?

3766


How to start a workflow using pmcmd command?

689


Can we create two repositories on same database instance in oracle?

588


How you know when to use a static cache and dynamic cache in lookup transformation?

1310


expain about the tune parameters?

1857


What are the types of schemas we have in data warehouse and what are the difference between them?

503


How can we delete duplicate rows from flat files?

712


explan ur project architecture?

1571