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

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,


list out all the transformations which use cache?

0 Answers   Informatica,


I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  


how did u understand business requirement?

2 Answers   TCS,


HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  






What is the function of union transformation?

0 Answers  


In Which scenario did u used Incremental loading?

2 Answers  


Did u used latest transformations of 8.6.0? for what?

0 Answers  


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,


What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,


What are the mapings that we use for slowly changing dimension table?

2 Answers  


Categories