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
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
list out all the transformations which use cache?
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
how did u understand business requirement?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
What is the function of union transformation?
In Which scenario did u used Incremental loading?
Did u used latest transformations of 8.6.0? for what?
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,
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?
What is deployemnt groups, Lables, query and dynamic deployment group.
What are the mapings that we use for slowly changing dimension table?