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
- 7041 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 to recover the standalone session?
Why we use ENABLE HIGH PRECISION in session properties?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
What is sql query override? When did u use sql query override?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
how to create user defined function (udf) in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Describe expression transformation?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
in performance wise union is past,union all is past
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
Teradata 
