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 8538

What is Relational Integrity?

1 3978

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

1 4406

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

1 12170

How to Check the source record count from traget table.

IBM,

5 14000

how to load the data to fact table?

2638

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

IBM,

2443

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 7748

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,

2311

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 6670

What is the main difference between peek stage and copy stage

2 18663

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 8246

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

1950

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,

2495

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 5075

Post New ETL Questions

Un-Answered Questions { ETL }

how many maximum session supports to multiload in teradata ??

2042

what is session partitioning?

1826

Explain about hash partitioning?

933

What is etl tool in hadoop?

839

How many steps etl contains?

879

What is tracing level?

1010

Explain about enterprise scalability and roi of data integration suite?

833

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

824

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

2443

how do u really know that paging to disk is happening while u are using a lookup transform?

2377

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

1344

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 ?

2061

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

4050

Explain the key challenges that you face while performing etl testing.

949

What are the steps involved in etl process?

952

For More Un-Answered { ETL } Questions Click Here