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
- 13517 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
what is the hint? how to use it to reduce the query processing in program?
What are the types of lookup transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are ETL Tools?
What is standalone command task?
what is index?how it can work in informatica
What is a code page?
Why union transformation is an active transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain pmcmd command usage in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are data-driven sessions?
What are the differences between a connected lookup and unconnected lookup?
What is a connected transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
