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

2203

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

2237

Can we create Hierarchies in generic datasources?

CTS,

2376

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

2 5713

tell me few points when u become TL

Infosys,

2537

what make u disappointmnets in u r career

Infosys,

2191

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.

2208

Hi, Lookup() is what kind of join ?

Satyam,

6 12195

what is the difference between cubes and package in cognos

Cognizant,

4948

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

HCL,

1 4317

How we can see table structure?

iGate,

2 6734

What exact we can see in table?

1 3930

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,

2692

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 6200

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

Tech Mahindra,

4108

Post New ETL Questions

Un-Answered Questions { ETL }

What is a materialized view log?

992

Explain me ETL project architecture in Detail?

2366

What are the various tools used in etl?

1041

Explain about the data integration suite features?

943

When do we analyze the tables?

957

What do you understand by the term ‘transformation’?

1031

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1950

what is the difference between cubes and package in cognos

4948

what are the types in error loging?

2146

what are the production issues in datastage?

10416

how do u set partition points in the mapping?

2590

Explain about enterprise scalability and roi of data integration suite?

875

Compare ETL & Manual development?

941

Can we create Hierarchies in generic datasources?

2376

Explain the use lookup tables and Aggregate tables?

973

For More Un-Answered { ETL } Questions Click Here