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

IBM,

4 13753

what are Lookup caches options? Including persistent caches.

 1431

Difference between flat files and relational sources?

Satyam,

1724

what is session partitioning?

 1 3234

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

CTS,

2 6229

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

 2 5040

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

 1515

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

 1504

how do u decide whether u need to do aggregations at database level or at Informatica level?

QualTech,

1 2483

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

 1628

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

 1458

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

 1543

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

 1551

how do u set partition points in the mapping?

 2090

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

 1825

Post New ETL Questions

Un-Answered Questions { ETL }

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

775

what is granularity in Data ware House?

1158

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

607

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

2041

how to connect to a flatfile through ftp in informatica

13424




Explain the use lookup tables and Aggregate tables?

538

Define slowly changing dimensions (SCD)?

603

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

843

What are cubes and olap cubes?

573

How many types of transformations supported by sorted input?

680

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

1838

what is session partitioning?

1451

what is the difference between cubes and package in cognos

4514

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1458

What are the key benefits of ETL Testing?

558

For More Un-Answered { ETL } Questions Click Here