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
- 7168 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
Have you worked with/created Parameter file
What are active and passive transformations?
What is rank index in rank transformation?
What is an Integration service in Informatica?
Differentiate between a repository server and a powerhouse?
Explain the difference between mapping parameter and mapping variable?
Explain why we use partitioning the session in informatica?
How to use pmcmd utility command?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How might you approve all mappings in the archive all the while?
Explain load alternative records / rows into multiple targets - informatica
have u done any performance tuning? how u ll do?
What does “tail –f” command do and what is its use as an Informatica admin.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Could you explain what is enterprise data warehouse?
