| Other ETL Interview Questions |
|| Asked @
|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
|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 should one create lookup transformation ?
|you have created a lookup transformation for a certain
condition which if true returns multiple rows. when you go
to the target and see only one row has come and not all. why
is it so and how it can be corrected.
|what is the difference between date cache and lindex cache?
|How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)
|What is the main difference between peek stage and copy
|what is a parameter when and where do u them when does the
value will be created. Designing time, run time. If u don't
create parameter what will happen?
|how to answer the question "explain project architecture" in
pls any one who has the answer pls send the answer to this
|what are Lookup caches options? Including persistent caches.
|what is a test load?
|Can we parametrize the values of IN statement.
Inside parameter file:
IN (INPUT_CHARACTER, $$Parameter)
|For more ETL Interview Questions Click Here |