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
What is union transformation in informatica?
What are the restrictions of union transformation?
What is olap (on-line analytical processing?
How to call shell scripts from informatica?
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
What are the different options available for update strategy?
What are the different clients of powercenter?
What is Cognos script editor?
How to start a workflow using pmcmd command?
Can we create two repositories on same database instance in oracle?
How you know when to use a static cache and dynamic cache in lookup transformation?
expain about the tune parameters?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we delete duplicate rows from flat files?
explan ur project architecture?