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.

 765

Explain in detail scd type 2 through mapping.

 609

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

 697

Explain the different kinds of facts.

 558

How do you load only null records into target?

 733

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

 610

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

 577

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

 688

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

 1490

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

 570

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

 615

Briefly explain input and put function?

 621

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?

 666

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

 561

Un-Answered Questions { Data Warehouse }

What are the facts that can compromise data integrity?

621

how u will determine the performence tune will occur either in report or system

1672

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

619

What are the functions performed by bynet?

601

in oracle target stage when we use load option and when we use upsert option?

1744




Start a batches with in a batch?

547

On which transformations you created partitions in your project?

757

difference between informatica 8.1.1 and 8.6

3236

If informatica has its scheduler why using third party scheduler?

763

what is the Default Source Option For Update Strategy Transformation?

751

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2303

How to load a Dimension ? and how to load a fact table?

948

What is package in BO

2679

what is the meant by Normalization and de-normalization?

2229

What actually a project contains?

639

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