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
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 |
why we are using level option in normalizer transformation
What is transformation?
Without using any transformations how u can load the data into target?
Can you create a flatfile target
In a table, 4 person having same salary. How to get Third person record only?
To achieve the session partition what r the necessary tasks u have to do?
What are limitations of joiner transformation?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is DR strategy for Informatica project?
Explain the pipeline partition with real time example?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.