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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Explain the different dimensions.

 553

Differentiate between source qualifier and filter transformation?

 999

Explain scd type 3 through mapping.

 578

What is dimensional table?

 619

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

 1009

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

 634

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

 634

Explain in detail about scd type 1 through mapping.

 589

Write the unconnected lookup syntax?

 656

Write the unconnected lookup syntax and how to return more than one column.

 591

How do you remove duplicate records in informatica? And how many ways are there to do it?

 713

What is dimensional table? Explain the different dimensions.

 658

What are the types of caches in lookup?

 568

What are the types of caches in lookup? Explain them.

 552

Differentiate between router and filter transformation?

 613

Un-Answered Questions { Data Warehouse }

What are the differences between star and snowflake schema?

492

Explain substr function?

575

Compare cold fusion with other programming languages?

556

Can you fastexport a field, which is primary key by putting equality on that key?

707

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

1684




what is power prompt in cognos ep7series?what is the use of this?

3201

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1662

Can tm1 web be set up for load balancing?

5

What is cognos powerhouse?

584

Briefly explain input and put function?

626

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

663

Database in use is oracle?

599

What are the components of Informatica? And what is the purpose of each?

620

what is data modeling?

1899

What is Fullouterjoin?

1551

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