| Other ETL Interview Questions |
|| Asked @
|Two different admin users created for repository
|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
|what is a test load?
|Can u access a repository created in previous version of
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?
|What is factless fact schema?
|how do u automate Extraction process?
|what is the difference between shortcut of an object and
copy of an object? compare them?
|WHY CANT WE SEE THE DATA IN DATASET
|what types of repositories we can create in informatica?
in real time in which type of repository we will work on?
|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
|indatastage 8.1 surrgoate key generates seqences numbers
write but there is limite value i want to reset the seqence
after gettting some highest value like i want o/p like this
1 2 3 4 5 .............10000 1 2 3.........10000
|For more ETL Interview Questions Click Here |