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
- 7015 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / moorthy g
S-->SQ-->EXP-->AGG--->TGT
EXP:
Create Variable port:
res: decode(col1=prev_col1,concat(res,col2), col2)
O_put: res
pre_col1=col1
AGG:
group by col1
| Is This Answer Correct ? | 2 Yes | 1 No |
What is the status code in stored procedure transformation?
Tell me one complex query in oracle ?
Why we use ENABLE HIGH PRECISION in session properties?
How do you do error handling in Informatica?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
can we use bulk loading when we use look in mapping
Which development components of informatica have the highest usage?
Which files are created during the session rums by informatics server?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
State the differences between sql override and lookup override?
Teradata 
