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
- 7170 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 |
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
normalizer transformation
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
What are the different tools in workflow manager?
Which files are created during the session rums by informatics server?
How you know when to use a static cache and dynamic cache in lookup transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Can we call a stored procedure from a unix script which is run using command task
Where do we use mapping variables in informatica?
What is informatica? Why do we need it?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
Teradata 
