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
- 13645 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 joiner transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the pipeline partition with real time example?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What all are steps in up gradation of Informatica server?
what is the size of u r source(like file or table)?
How are the sources and targets definitions imported in informatica designer?
On which transformations you created partitions in your project?
What is a pre-defined event and user-defined event?
What are the main issues while working with flat files as source and as targets ?
Explain transaction control transformation in informatica
difference between repository database and repository service?
What is a snowflake schema?
What are the types of schemas we have in data warehouse.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
