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 / jaspreet banga
after source qualifier, Use an expression transformer , in
that take an variable port name 'FLAG', and in that use the
decode function as 'FLAG = DECODE(GENDER=MALE,'M','F')'.
after that place an router transformer and for each flag
condition use seperate instance of target and hence you
will get what you want.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is Data Caches size?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Where can we find the throughput option in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the Rank index port in Rank transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How you know when to use a static cache and dynamic cache in lookup transformation?
Enlist the tasks for which source qualifier transformation is used.
Is stop and abort are same in informatica?
Explain why we use partitioning the session in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How many input parameters can exist in an unconnected lookup?