If the source has duplicate records as id and name columns,
values:
1 a, 1 b, 1 c,
2 a, 2 b,
the target should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?
Answer Posted / mithilesh kumar rai
First Use Expression and then Use Aggregater
After Expression U will receive
1 a
1 a b
1 a b c
2 a
2 a b
2 a b c
then use aggregater group by key 'ID'
After Aggregater u will receive
1 abc
2 abc
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is olap (on-line analytical processing?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How can we handle two sessions in informatica?
Explain the difference between mapping parameter and mapping variable?
What is incremental aggregation?
How might you approve all mappings in the archive all the while?
Explain what transformation and how many are there in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
explan ur project architecture?
Explain the different dimensions.
How to elaborate tracing level?
What is different between the data warehouse and data mart?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is domain and gateway node?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?