ETL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

ETL Interview Questions

Questions Answers Views Company eMail

what do u do when DB time takes more?in sap bi

2205

what is the use of structures?how many nodes can u create in a structure?

2239

Can we create Hierarchies in generic datasources?

CTS,

2384

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 5727

tell me few points when u become TL

Infosys,

2553

what make u disappointmnets in u r career

Infosys,

2197

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2212

Hi, Lookup() is what kind of join ?

Satyam,

6 12213

what is the difference between cubes and package in cognos

Cognizant,

4949

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

HCL,

1 4331

How we can see table structure?

iGate,

2 6746

What exact we can see in table?

1 3935

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

Thomson,

2696

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

Cognizant, IBM,

2 6208

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

Tech Mahindra,

4112

Post New ETL Questions

Un-Answered Questions { ETL }

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2035

What is a staging area? What is the purpose of a staging area?

885

Explain etl mapping sheets?

1077

what is dynamic insert?

2202

How many steps etl contains explain with example?

970

Give the benefits of data integration suite?

921

How many steps etl contains?

944

what is granularity in Data ware House?

1724

what is pmrep command?

2438

how do u handle performance issues in Informatica . where can u monitor the performance ?

4737

Two default user groups created in the repository are____and_____.

2047

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1539

can cubes contain measures ?

2027

Define Dynamic push down optmization?

2301

what is an ETL or ETT? And what are the different types?

7495

For More Un-Answered { ETL } Questions Click Here