source : col1 101 101 101 102 102 102 103 103 103
col2 1000 1500 2000 1200 2300 3000 2400 1300 2000
i need target as
col1 101 102 103
col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
Answer Posted / venky
src->exp->agg->tgt
exp transformation
col1
col2
var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output=var1
agg transformatiom
col1 select group
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
What is rank transformation?
What is the use of an aggregator cache file?
How do you use reject loader.
What is status code in informatica?
Explain informatica architecture - version 8 / 9
Explain the features of connected and unconnected lookup.
What is different between the data warehouse and data mart?
What are the prerequisite tasks to achieve the session partition?
What does cheating measurement mean?
What is Data Caches size?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why union transformation is an active transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain incremental aggregation in informatica