| Other ETL Interview Questions |
|| Asked @
|list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
|can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
|what are the parts of Informatica server ?
|what are Lookup caches options? Including persistent caches.
|what is the difference between normal & bulk loading? and
which one is recommended ? why?
|1. if lookup tr is giving poor performamence. what u do.
2. i have emp,dept table. i want output
3. can any one tell me project flow in real time scenario.
please send me mail any queries and answers
my mail id is firstname.lastname@example.org
|we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record
|what is SMP AND MPP?
|IN Informatica, I have 10 records in my source system. I need
to load 2 records to target for each run. how to
perform.please let me know. I know by using Mapping variable
we can perform but how to load please any one explain.
|how do u automate Extraction process?
|How to Check the source record count from traget table.
|how do u implement unconn.stored proc. in a mapping?
|For more ETL Interview Questions Click Here |