1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is session partitioning?

 1459

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

 5 14528

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

 1503

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

 1 3437

what is pmrep command?

 1 10802

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

 1 4767

Can u access a repository created in previous version of Informatica?

 1466

Eliminating of duplicate records without using dynamic lookups

 3 6478

what are Lookup caches options? Including persistent caches.

 1 4020

Difference between flat files and relational sources?

 2 5180

what is session partitioning?

 1561

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

 2 6355

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

 2170

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

 2 7436

what are the different forms of normalization?

 2 4764

Un-Answered Questions { Data Warehouse }

What is a fact, dimension, measure?

551

what is the size of u r source(like file or table)?

1812

Write different kinds of objects in microstrategy?

594

Can you execute a macro within a macro? Describe. : sas-macro

667

What are the different types of segments?

545




what is the use of server?

1735

Where do we use mapping variables in informatica?

611

What are data modeling and data mining? Where it will be used?

541

how do use session mapping parameters ?(in which transformation)

1438

Explain the difference between a data warehouse and a data mart?

594

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10274

What Proc glm does?

608

what is operational data and operational system? : Sas-di

631

generate date / time dimension in informatica

717

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527

For More Un-Answered { Data Warehouse } Questions Click Here