my source has 2 columns. 1st column data: ABC ABC ABC XYZ
and 2nd column data: 1 2 3 4. And my target should be ABC 1 2
3, XYZ 4
Answer Posted / shiva
col1 col2 COL1 COL2
ABC 1 ABC 1,2,3
ABC 2 XYZ 4
ABC 3
XYZ 4
S-SQ-AGG-SORT-TGT
IN AGG TAKE 4 VARIABLE PORTS
1)V_COL1 (in this write) v_cur_col1
2)v_cur_col1 (in this write) col1
3)flag (in this) iff(col1=v_col1,1,0)
4)v_col2 (in this ) decode(flag=1,v_col2||,||col2,col2
5)o_col2 (in this) v_col2 (this is a o/p port)
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
What is meant by lookup transformation?
What is rank index in rank transformation?
How might you approve all mappings in the archive all the while?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you convert single row from source into three rows into target?
What are the prerequisite tasks to achieve the session partition?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Do you find any difficulty while working with flat files as source and target?
How to create a non-reusable instance of reusable transformations?
What are session parameters ? How do you set them?
Briefly define reusable transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the difference between Active and Passive transformation?
What is status code in informatica?