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
- 13476 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to extract sap data using informatica?
Informatica settings are available in which file?
How is union transformation utilized?
What is meant by LDAP users?
What does reusable transformation mean?
What are the components of the workflow manager?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How do you change a non-reusable transformation to reusable transformation?
How to join three sources using joiner?
What are the main issues while working with flat files as source and as targets ?
Why sorter is an active transformation?
Can we override a native sql query within informatica?
explain about unit testing? in real time?
What is an aggregator transformation?
What is incremental aggregation?
