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
- 13024 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
Which files are created during the session rums by informatics server?
what are 3 tech challenges/ common issues you face?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the difference between informatica 7.0 and 8.0?
Define joiner transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the tasks that can be performed using sq?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What do mean by local and global repository?
How would you copy the content of one repository to another repository?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the difference between informatics 7x and 8x and what is latest version?
Clarify the aggregator change?
What is a difference between complete, stop and abort?
