ETL Interview Questions
Questions Answers Views Company eMail

What are the three tiers in etl?

582

What are dimensions?

570

What are the steps involved in etl process?

509

What is initial load and what is full load?

505

Explain different types of partitioning?

611

List few etl bugs?

517

What are three tier systems in etl?

611

What are your responsibilities as an etl tester?

612

What is grain of fact?

534

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

545

What do you understand by the term ‘transformation’?

515

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

561

Mention few test cases and explain them?

539

Explain etl mapping sheets?

651

What is tracing level and what are the types?

525


Post New ETL Questions

Un-Answered Questions { ETL }

How can we use external procedural logic in informatica?

524


What is fact? What are the types of facts?

532


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1363


what do u do when DB time takes more?in sap bi

1777


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

846






what is the difference steps for data modeling?

2069


Explain etl?

566


Explain different types of partitioning?

611


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

496


what is session partitioning?

1453


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.

1915


What is tracing level and what are the types?

525


Can there be sub steps of etl steps?

525


Explain etl mapping sheets?

651


Difference between flat files and relational sources?

1764