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

ETL Interview Questions

Questions Answers Views Company eMail

What are the new features of informatica 9 version?

2 8665

What is Relational Integrity?

1 4098

working of line item dimension......pls,tell overall flow

1 4500

If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).

1 12276

How to Check the source record count from traget table.

IBM,

5 14279

how to load the data to fact table?

2709

Can anyone explain me a scenario from banking and finance...more precisely a mapping

IBM,

2499

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 7849

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

HCL,

2364

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

HCL, iGate,

2 6804

What is the main difference between peek stage and copy stage

2 18805

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 8446

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2002

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

L&T,

2557

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

TCS,

1 5191

Post New ETL Questions

Un-Answered Questions { ETL }

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

4740

what happens if the info.server doesn't find the session parameter in the parameter file?

1953

What is grain of fact?

984

What are three tier systems in etl?

1066

What are the steps involved in etl process?

1030

What are the key benefits of ETL Testing?

1055

what is data modeling?

1914

SCD2 will work on only dimension tables as well as fact Table?

1402

flat filevalidation in informatica

2157

When do we analyze the tables?

978

what is the meaning of upgradation of Repository?

3748

what are Lookup caches options? Including persistent caches.

1977

Explain the use lookup tables and Aggregate tables?

977

what is the difference steps for data modeling?

2606

what is the use of server?

2203

For More Un-Answered { ETL } Questions Click Here