| Other ETL Interview Questions |
|| Asked @
|what are the facilities provided by OLAP to analytical users?
|what are variable ports and list two situations when they
can be used?
|without using ETL tool can u prepare a Data warehousing and
|How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)
|what is the difference between shortcut of an object and
copy of an object? compare them?
|what are the different forms of normalization?
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?
|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.
|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
|working of line item dimension......pls,tell overall flow
|Eliminating of duplicate records without using dynamic lookups
|how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
|For more ETL Interview Questions Click Here |