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 / balaganesh
SQ-->SRT-->EXP-->AGG-->TGT
In SRT:
sort the record by col1 (Ascending)
In Exp:
col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_maxcount=iif(v_col1=col1,v_maxcount+1,1)
v_col1=col1
o_col1=v_col1
o_col2=v_col2
o_maxcount=v_maxcount
In AGG:
Group by o_col1
MAX(o_maxcount)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is a dimensional model?
how to load rows into fact table in data warehouse
How to delete duplicate row using informatica?
How to use procedural logic inside infromatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain dynamic target flat file name generation in informatica
What do you understand by a term domain?
what is index?how it can work in informatica
According to his methodology what all you need before you build a datawarehouse
whats the logic to load the lower level of granularity of data to fact table.
Briefly define reusable transformation?
What are the different types of transformation available in informatica.
What is enterprise data warehousing?
tell me 5 session failure in real time how can you solve that in your project?