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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is session partitioning?

 1463

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

 5 14546

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

 1508

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

 1 3450

what is pmrep command?

 1 10816

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

 1 4779

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

 1474

Eliminating of duplicate records without using dynamic lookups

 3 6495

what are Lookup caches options? Including persistent caches.

 1 4027

Difference between flat files and relational sources?

 2 5194

what is session partitioning?

 1566

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

 2 6371

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

 2180

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

 2 7447

what are the different forms of normalization?

 2 4778

Un-Answered Questions { Data Warehouse }

How does a sorter cache works?

573

What are the benefits of datastage?

732

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

558

what are all the reports you generated in your recent project?

1687

What is joiner transformation in informatica?

629




How to create Target definition for flat files?

756

Can you define cube?

595

What is model filter?

632

What is ods (operation data source)?

555

what is data integration? : Sas-di

616

What happens if the owner of an object does not exist in the destination project?

528

What is defined as catalog and types of catalogs in Cognos?

571

How many numbers of sessions can one group in batches?

625

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

781

Code check-in and check-out commands in AbInitio

3373

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