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 5729

tell me few points when u become TL

Infosys,

2556

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.

2213

Hi, Lookup() is what kind of join ?

Satyam,

6 12215

what is the difference between cubes and package in cognos

Cognizant,

4950

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

HCL,

1 4333

How we can see table structure?

iGate,

2 6749

What exact we can see in table?

1 3936

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,

2698

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 6213

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

Tech Mahindra,

4113

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?

2036

Explain me ETL project architecture in Detail?

2371

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2120

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2629

what is the difference between cubes and package in cognos

4950

what is the use of server?

2198

What is partitioning? Explain different types of partitioning?

1242

how do u set partition points in the mapping?

2596

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

4739

flat filevalidation in informatica

2155

what is different between sequential batch and concurrent batch and which is recommended and why?

4929

What is a mapping?

990

What is data cleaning?

943

Compare etl & elt?

1012

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

977

For More Un-Answered { ETL } Questions Click Here