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
what is the difference between stop and abort?
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?
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
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
permutations of mapplet
What is aggregator transformation in informatica?
why do u use shortcuts in informatica.?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Differnce between filter and router?
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?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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