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

2206

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

2240

Can we create Hierarchies in generic datasources?

CTS,

2387

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

2 5739

tell me few points when u become TL

Infosys,

2563

what make u disappointmnets in u r career

Infosys,

2201

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.

2219

Hi, Lookup() is what kind of join ?

Satyam,

6 12228

what is the difference between cubes and package in cognos

Cognizant,

4953

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

HCL,

1 4338

How we can see table structure?

iGate,

2 6758

What exact we can see in table?

1 3942

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,

2703

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 6227

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

Tech Mahindra,

4115

Post New ETL Questions

Un-Answered Questions { ETL }

What is the difference between round-robin partitioning and hash partitioning?

974

What is fact? What are the types of facts?

1120

Give the benefits of data integration suite?

924

What is staging area referring to?

1134

Compare etl & elt?

1017

What is tracing level and what are the types?

969

Explain about hash partitioning?

1004

How etl testing is different from database testing?

1056

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2235

How to increase performance without changing anything in mapping.( In prod)

1266

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

1010

When do we analyze the tables? How do we do it?

963

What are cubes and olap cubes?

989

flat filevalidation in informatica

2158

can cubes contain measures ?

2034

For More Un-Answered { ETL } Questions Click Here