Interested to Buy Any Domain ? << Click Here >> for more details...
In a simple mapping when i use aggregate t/r with out any
condition or group by, i am getting output as only last
record in the table . can any one explain it please.........?
- 4 Answers
- 7064 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
By Default informtica finds a group on the basis of your group by check boxes and returns you last row of each group when you don't specify any group by clause then it takes whole data set as a single group and returns you the last row of that whole group...
please make me correct if i am wrong..
http://deepinopensource.blogspot.in
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How many number of sessions can one group in batches?
What's the layout of parameter file (what does a parameter file contain?)?
explain one complex mapping with logic? sales project?
What are the different types of olap? Give an example?
Write the different tools in the workflow manager?
How to generate sequence numbers without using the sequence generator transformation?
Explain sql transformation in script mode examples in informatica
Explain 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?
Differentiate between joiner and lookup transformation?
What is the difference between Active and Passive transformation?
What is complex mapping?
What is union transformation?
what is the size of u r source(like file or table)?
without table how to come first record only in oracle?
