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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

 762

Explain in detail scd type 2 through mapping.

 607

How do you load unique records into one target table and duplicate records into a different target table?

 695

Explain the different kinds of facts.

 554

How do you load only null records into target?

 732

What is fact table? Explain the different kinds of facts.

 608

How many ways are there to do 'remove duplicate records in informatica'?

 574

How to join three sources using joiner? Explain though mapping flow.

 686

How do you load only null records into target? Explain through mapping flow.

 1488

I have a dataset concat having variable a b & c. How to rename a b to e & f?

 568

How do you specify the number of iterations and specific condition within a single do loop?

 613

Briefly explain input and put function?

 619

Give some examples where proc report’s defaults are same as proc print’s defaults?

 631

What is the length assigned to the target variable by the scan function?

 665

What is the difference between one to one merge and match merge? Give an example.

 560

Un-Answered Questions { Data Warehouse }

Explain about power designer data modeling software?

457

Explain about Informatica server process that how it works relates to mapping variables?

616

How will you enable or disable caching in the system level and table level?

469

in general which algorithms for used?

1541

What is m_dump?

726




can anyone explain me about retail domain project in informatica?

7417

how sas deals with business intelligence? : Sas-bi

575

What can be achieved by using the teradata rdbms?

617

Make a note of the quantity vaults made in informatica?

545

Describe the ways in which you can create a macro variable?

612

What is the difference between datawarehouse and bi?

507

I need level 2 to 5 sas using companies in india

1919

what is information maps?

1603

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1401

what are the special features in cognos reportnet?

608

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