Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10823 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
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
What is the difference between informatica 7.0 and 8.0?
What happens when a session fails and you click on recover?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is index?how it can work in informatica
Difference between Data and Index Caches?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is source qualifier transformation in informatica?
What are the components of workflow manager?
define galaxy repository in informatica
What are the databases that informatica can connect to windows?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the settings that you use to configure the joiner transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
