Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7135 Views
- Zensar, I also Faced
- E-Mail Answers
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
Performance tuning( what you did in performance tuning)
How can we use mapping variables in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
which one is better performance wise joiner or look up
What is the scenario which compels informatica server to reject files?
What is a grid in Informatica?
What is a passive transformation?
What is expression transformation?
Mention few power centre client applications with their basic purpose?
EXL informatica Questions
How will the document be delivered to me?
Explain target update override in informatica
Explain pmcmd command usage in informatica
Which files are created during the session rums by informatics server?
During the running session, output files are created by informatica server. Enlist few of them.
