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
- 13812 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 |
What is hash partition?
waht type of interface is used for testing the data in informatica
Why we use ENABLE HIGH PRECISION in session properties?
What are the different types of code pages available in informatica & how to implement it in your project?
What is the difference between source qualifier transformations source filter to filter transformation?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
What is surrogate key?
Clarify the aggregator change?
what is dynamic cashe
what are the Methods For Creating Reusable Transformations?
What is workflow? What are the components of the workflow manager?
how do u use sequence created in oracle in informatica? Explain with an simple example
Teradata 
