| Other ETL Interview Questions |
|| Asked @
|we hava a flat file having more than 1000 records and two
targets. i have to write first half of the rows into first
targets and next half of rows into second target. how can i
do in informetica??
|working of line item dimension......pls,tell overall flow
|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
|If you concatenate data from a normalizer
transformation,the ports you concatenate cannot include
|what is the difference between normal & bulk loading? and
which one is recommended ? why?
|How to Check the source record count from traget table.
|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
|how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
|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 email@example.com
|When you have 2 servers in two different time zone and if
you need to extract data from 1 server and load it in
another server, how do you go about it? Best method to be
Lookup() is what kind of join ?
Source Table(Flat File):- Target Table(Flat File):-
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
|For more ETL Interview Questions Click Here |