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
- 13799 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 might you approve all mappings in the archive all the while?
Make a note of the quantity vaults made in informatica?
What is status code in informatica?
What are the components of workflow manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is standalone command task?
What is substr in informatica?
What is a surrogate key?
How many numbers of sessions can one group in batches?
What are the advantages of using informatica as an etl tool over teradata?
what is mean by complex business rule ?
What are the uses of etl tools?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Global and Local shortcuts. Advantages.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
