Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?


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

Post New Answer

More Informatica Interview Questions

what is the difference between stop and abort?

3 Answers   TCS,


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,


following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  


permutations of mapplet

0 Answers   TCS,






What is aggregator transformation in informatica?

0 Answers  


why do u use shortcuts in informatica.?

4 Answers   iFlex,


we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


Differnce between filter and router?

14 Answers   IBM,


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


Categories