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

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.

 1562

what is meant by drill through?(Mascot)

 1 2108

what are the different Reporting and ETL tools available in the market?

 3 10975

explain the methodology of Data Warehousing?(Polaries)

 1804

what are the concerns of OLTP and DSS systems?

 1559

what is the difference between OLTP database and data warehousing database?

 4 6077

what is data modeling?

 1475

what is the difference steps for data modeling?

 1591

what are the data modeling tools you have used?(polaris)

 3806

what is the difference between cardinality and Nullability?

 2836

what is Forward,Reverse and Re_engineering?

QualTech,

1775

what is the meant by Normalization and de-normalization?

 2239

what are the different Reporting and ETL tools available in the market?

 3 12003

explain the methodology of Data Warehousing?(Polaries)

 1484

what are the concerns of OLTP and DSS systems?

TCS,

1975

Post New ETL Questions

Un-Answered Questions { ETL }

Explain about the data integration suite features?

477

what is data modeling?

1907

What is a materialized view log?

554

Do we need an etl tool?

559

Can we create Hierarchies in generic datasources?

1930




Explain do we need an etl tool?

531

What is etl process? How many steps etl contains?

601

how to connect to a flatfile through ftp in informatica

13447

Do we need an ETL tool? When do we go for the tools in the market?

530

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

1639

In Which Transformation We Can Use Having Clause In Informatica?

829

how to load the data to fact table?

2155

How to fine tune mappings?

568

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

1787

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

1841

For More Un-Answered { ETL } Questions Click Here