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.

744

Explain in detail scd type 2 through mapping.

583

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

680

Explain the different kinds of facts.

541

How do you load only null records into target?

716

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

591

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

559

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

668

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

1461

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

552

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

596

Briefly explain input and put function?

599

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

616

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

651

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

542


Un-Answered Questions { Data Warehouse }

sed,awk,head

947


what is SDLC way of code development?

1536


How to do unit testing in informatica? How to load data in informatica ?

625


How can one find bugs in job sequence?

755


Explain what is the difference between powerplay transformer and power play reports?

615






Why is chameleon method used in data warehouse?

666


explain what is factor analysis? : Sas-administrator

578


what are the names of the reports that you prepared?

604


What are the statements that are executed only?

651


What are session parameters ? How do you set them?

1351


what are the deliverables?in your project?

1624


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2286


what is the basic structure sas administrator? : Sas-administrator

541


--------------Explain Table of contents?

1532


Can you define fan trap?

726