What differs when we choose the sorted input for aggregator transformation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,


Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


Explain pushdown optimization and types in informatica

0 Answers   Informatica,


When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  






What are the new features of informatica 7.1?

2 Answers  


what is a time dimension? give an example?

2 Answers   IBM,


without table how to come first record only in oracle?

0 Answers  


Clarify the utilization of aggregator cache record?

0 Answers  


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  


pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


Categories