What is the need for an etl tool?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer



More Informatica Interview Questions

What do you mean by filter transformation?

0 Answers  


if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  


Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,






How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,


whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,


What is joiner transformation in informatica?

0 Answers  


how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,


1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


Categories