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
- 7095 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
What is a repository manager?
What is a connected transformation?
How we can use union transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is informatica?
What are the components of the workflow manager?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
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?
What do you mean by enterprise data warehousing?
can you please explain me pre session and post session options?
What is data movement mode in Informatica and difference between them?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What all join we can perform in LOOKUP transformation?
how to load rows into fact table in data warehouse
What is the difference between informatics 7x and 8x and what is latest version?
