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
- 13677 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
Define enterprise data warehousing?
How would you copy the content of one repository to another repository?
What are the main features of Oracle 8i with context to datawarehouse?
How do you remove duplicate records in informatica? And how many ways are there to do it?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Differences between version 7.x and 8.x.
server hot-ws270 is connect to Repository B. What does it mean?
What are the advantages of using informatica as an etl tool over teradata?
How to partition the Session?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the use of target designer?
What is meant by incremental aggregation?
COM components can be used in Informatica
What are the databases that informatica can connect to windows?
What are the static cache and dynamic cache in informatica?
