What is the main difference between star and snowflake star schema? Which one is better and why?

543

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

555

ware house management system is used?

568

Which columns go to the fact table and which columns go the dimension table?

555

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

511

What is a data profile?

563

Explain what are the different types of data warehousing?

506

Explain the difference between filter and conditin?

553

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

1666

How to pivot row data using informatica?

498

What is the working process for application.cfm?

537

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

1668

What is drilling across?

547

Why we use repository connectivity?

532

How to load the time dimension?

528