| Other ETL Interview Questions |
|| Asked @
|what types of repositories we can create in informatica?
in real time in which type of repository we will work on?
|what are variable ports and list two situations when they
can be used?
|In the SEQ generator which property has to be set to
generate seq No. when the input data is more than the max
|how do u implement unconn.stored proc. in a mapping?
|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 to load Session Statistics (Workflow name, TgtRows,
Rejected Rows, SessStartTime,SessEndTime..)into a database
table ?? Another Question: I want to pass values from
oracle table or Flat file in Mapping parameter/Variable..
What is the method for that..Please provide me the solution
step by step
|when should one create lookup transformation ?
Lookup() is what kind of join ?
|what is HISTOGRAM? how to generate statistics?
|what are the different Reporting and ETL tools available in
|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
|what is the indicator file and where it is used?
|For more ETL Interview Questions Click Here |