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
- 9298 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / john coder
i believe, we need an aggregator to pick up the last row for
a particular deptno.
Otherwise, there will be three rows inserted...
col1 col2
101 1000
101 1000,1500
101 1000,1500,2000
by having an aggregator with groupby on col1, we can pick up
the last row by either using LAST or MAX.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain your project of banking domian.
Briefly define a session task?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
explain abt ur project architecture?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is dimensional table? Explain the different dimensions.
Mention a few design and development best practices for informatica?
What is Cognos script editor?
Can anyone tell me the new features in Informatica 9 Version?
What is powercenter on grid?
How can one identify whether mapping is correct or not without connecting session?
Enlist the various types of transformations.
Explain about cumulative Sum or moving sum?
Explian the Process of deployment groups in informatica
