1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category
ETL Interview Questions
Questions Answers Views Company eMail

Eliminating of duplicate records without using dynamic lookups

 3 6462

what are Lookup caches options? Including persistent caches.

 1 4010

Difference between flat files and relational sources?

 2 5167

what is session partitioning?

 1555

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

 2 6339

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

 2157

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

 2 7411

what are the different forms of normalization?

 2 4754

what is an ETL or ETT? And what are the different types?

 6909

how do u extract data from different data sources explain with an example?

 1765

what are the reporting tools and difference between them?

 1578

how do u automate Extraction process?

 1 3980

without using ETL tool can u prepare a Data warehousing and maintaining?

 3 7064

how do u identify the changed records in operational data?

QualTech,

2125

what is SMP AND MPP?

 8 61423

Post New ETL Questions

Un-Answered Questions { ETL }

What are cubes and olap cubes?

572

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2038

What is etl process?

524

Explain etl mapping sheets?

650

list and discuss two approaches for updation of target table in Informatica and how they are different.

1720




how would u estimate the size of Lookup transform data and index cache?

1626

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

1533

Compare etl & elt?

540

What are various etl tools in the market?

515

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1815

Explain different types of partitioning?

609

What is lookup table in etl testing?

726

what is the meant by Normalization and de-normalization?

2224

what are the concerns of OLTP and DSS systems?

1961

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

528

For More Un-Answered { ETL } Questions Click Here