Interested to Buy Any Domain ? << Click Here >> for more details...
If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
- 3 Answers
- 13795 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh.a
We need to use sorter,Expression and aggregator transformations to do this
1.Sort by ID
2.Take 2 variable ports one for id and one for name and store the values of id and keep on comparing with current id i.e variable is having previous id.
so,if previous id=current id then (variable name)||name otherwise only name.assign the variable name to output port
3.Use aggregator and use last or max(len(name)) to get the result
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / saritha
you can use normalizer or expersion transformation.
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / somnath pain
In source qualifier use this query
select name from table_name group by id
now apply an aggregator transformation to concate the name
according to the group id.
| Is This Answer Correct ? | 2 Yes | 7 No |
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
How to update or delete the rows in a target, which do not have key fields?
In joiner, how to load Master table in Target?
Diffrence between static and dynamic cache
what is surrogate id ?
Reusable transformation and shortcut differences
What is the Difference between PowerPlay transformer and power play reports?
why we use stored procedure transformation?
Can yoU use the maping parameters or variables created in one maping into another maping?
How can we use mapping variables in informatica? Where do we use them?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Teradata 
