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
What is informatica? Why do we need it?
what is Active lock explain
Explain pmcmd command usage in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the Process to creating lookup transformation in informatica
expain about the tune parameters?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Scheduling properties,whats the default (sequential)
Write the unconnected lookup syntax?
What is rank index in rank transformation?
Parameter and variable differences
How do you manage the Parameter files while migrating your data from one environment to another environment?
On which transformations you created partitions in your project?
What is a rank transform?
What is the benefit of session partitioning?