If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?
Answer / akhil4
session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.
| Is This Answer Correct ? | 5 Yes | 1 No |
How to elaborate tracing level?
Why do we use DSS database for OLAP tools?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
How to compare Source and Target table, without using dynamic lookup?
What is an expression transformation?
How can you define a transformation? What are different types of transformations in Informatica?
Explain the difference between mapping parameter and mapping variable?
Tell me one complex query in oracle ?
what are the limitations of pushdown optimization technique ? Advance thanks
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.