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

ETL Interview Questions

Questions Answers Views Company eMail

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2183

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 6781

what is a test load?

3 16787

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2277

what is the difference between shortcut of an object and copy of an object? compare them?

1 6204

how do u implement configuration management in Informatica?

4798

what are business components in Informatica?

2 11176

dimension object created in oracle can be imported in designer?how?

2991

can cubes contain measures ?

2034

can be used COM component in Informatica ?

2065

what is the advantage of persistent cache? when it should be used?

2 4773

when will use SQL override in a lookup transformation?

2299

Two different admin users created for repository are________and_________.

1 3919

Two default user groups created in the repository are____and_____.

2055

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1866

Post New ETL Questions

Un-Answered Questions { ETL }

what is the difference between cardinality and Nullability?

3459

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

1992

What is data cleaning?

949

what are Lookup caches options? Including persistent caches.

1978

Which transformation we use to convert 'NA' to 'Not Available'

1271

Explain about etl data integration software?

894

What is staging area referring to?

1134

tell me few points when u become TL

2563

Explain do we need an etl tool? When do we go for the tools in the market?

1024

Mention few test cases and explain them?

934

Explain do we need an etl tool?

1028

Define slowly changing dimensions (SCD)?

1062

Compare ETL & Manual development?

958

What is meant by incremental load?

1100

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

950

For More Un-Answered { ETL } Questions Click Here