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?
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
Write the unconnected lookup syntax and how to return more than one column.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Differentiate between sessions and batches?
What are session parameters ? How do you set them?
Explain Dataware house architecture .how data flow from intial to end?
How many input parameters can exist in an unconnected lookup?
Explain constraint based loading in informatica
Where do we use mapping variables in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
What is decode in informatica?
What do you mean by enterprise data warehousing?
Explain the tuning lookup transformation - informatica
is it possible to index the data in cache of lkp transformation ?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How you prepared reports for OLAP?