Technical Interview Questions and Answers :: Informatica
11 / 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.
12 / 94
No Discussion on this question yet!
13 / 94
No Discussion on this question yet!
14 / 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 .
15 / 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
16 / 94
No Discussion on this question yet!
17 / 94
No Discussion on this question yet!
18 / 94
No Discussion on this question yet!
19 / 94
No Discussion on this question yet!
20 / 94
No Discussion on this question yet!