i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater
Answer Posted / sreenivas
it will return 100th row of the source if group by port is
not selected in aggregator
|Is This Answer Correct ?||10 Yes||0 No|
What is union transformation in informatica?
What are the different options available for update strategy?
What is meant by lookup transformation?
Can you generate sequence numbers without using the sequence generator transformation?
How do you load only null records into target? Explain through mapping flow.
How many numbers of sessions can one group in batches?
How do you load first and last records into target table?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
h0w many versions have been developed of onformatica so far?
What do you mean by blocking transformation?
Slowly changing dimensions, types and where will you use them
How would you copy the content of one repository to another repository?
Explain Dataware house architecture .how data flow from intial to end?
Explain the types of lookup transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks