we r using aggregator with out using groupby?
Answer Posted / neeraj
By default aggregator does group by on each of the input
port so if 50 distinct rows are coming all will pass
through it..
| Is This Answer Correct ? | 3 Yes | 23 No |
Post New Answer View All Answers
What are multi-group transformations?
Define enterprise data warehousing?
What is pmcmd command?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is informatica metadata and where is it stored?
What are the settings that you use to configure the joiner transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain how to import oracle sequence into informatica?
Explain the shared cache and re-cache?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
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.
Is it possible to use a client with different version than that of its Informatica server?
What is informatica powercenter repository?
can we override a native sql query within informatica? Where do we do it? How do we do it?