ETL Interview Questions
Questions Answers Views Company eMail

What is abap? What are idocs?

510

How can we use external procedural logic in informatica?

526

Do we need an etl tool?

554

What is etl process. How many steps etl contains explain with example?

515

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

486

Is hadoop a etl tool?

514

Is apache nifi an etl tool?

541

What is etl tool in hadoop?

492

Explain about power designer data modeling software?

459

Explain about the data integration suite features?

471

Explain about enterprise scalability and roi of data integration suite?

490

Give the benefits of data integration suite?

493

Explain about etl data integration software?

482

What is a lookup table in etl?

589

What is lookup table in etl testing?

730


Post New ETL Questions

Un-Answered Questions { ETL }

How many types of transformations supported by sorted input?

688


Identifying the bottlenecks in various components of Informatica and resolving them.

1503


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

2562


What is initial load and what is full load?

514


What do you understand by the term ‘transformation’?

520






What are the different etl testing categories as per their function?

532


What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

649


where we cannot use sorter Transformation. if we use then we will not get correct data?

1799


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.

1557


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

782


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.?

502


Is hadoop a etl tool?

514


what is session partitioning?

1458


What is the difference between project backlog and product backlog?

1026


explain the methodology of Data Warehousing?(Polaries)

1796