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

How Union Transformation is an Active Trans?

6 Answers  


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


scenario

1 Answers  


How can you run a session without using server manager?

1 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,






Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,


How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,


Explain how many types of dimensions are available in informatica?

0 Answers  


if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,


What is difference macros and prompts?

2 Answers  


what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  


Categories