If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / kt
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.
| Is This Answer Correct ? | 50 Yes | 1 No |
Post New Answer View All Answers
What is expression transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the guidelines to be followed while using union transformation?
What is sequence generator transformation in informatica?
What are the main issues while working with flat files as source and as targets ?
Can we get 1st record through Informatica(without sequence number).
What is informatica? Why do we need it?
On which transformations you created partitions in your project?
Different sorts of metadata that stores in the storage facility?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is Session and Batches?
What are multi-group transformations?
What are the differences between oltp and olap?