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
- 7164 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 |
why normalizer transformation can not used in mapplet? plzzzz answer
Without using any transformations how u can load the data into target?
What all are steps in up gradation of Informatica server?
What is a node in Informatica?
What are the new features of informatica 9.x at the developer level?
what is system requirement(SR) & business requirement(BR)?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
Can we update a target table (without primarykey) by using update strategy transformation?
How to eliminate duplicates from flat file..what is the procedure
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
Explain the use of aggregator cache file?
Teradata 
