Technical Interview Questions and Answers :: Informatica
41 / 94
Sorted input reduces the amount of data cached during the session and improves session performance.
so working of sorter before aggregator is a best practice.
42 / 94
No Discussion on this question yet!
43 / 94
No Discussion on this question yet!
44 / 94
TO FIND DUPLICATE IN ORACLE(SQL):
TABLE NAME: EMP.
SELECT * FROM EMP WHERE ROW ID NOT IN ( SELECT MAX(ROWID) FROM EMP GROUP BY COLUMN NAME);
NOTE: COLUMN NAME LIKE EMPID OR NAME AS PER NEED .
45 / 94
Look up transformation is a kind of join transformation.we can have a look to target table whether the incoming source table details are present in target table or not
46 / 94
No Discussion on this question yet!
47 / 94
No Discussion on this question yet!
48 / 94
No Discussion on this question yet!
49 / 94
No Discussion on this question yet!
50 / 94
No Discussion on this question yet!