What are the advantages of cold fusion?

907

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

878

Can you brief about the Data warehouse project you worked on?

2317

How to improve session performance in aggregator transformation?

935

What is the difference between er modeling and dimensional modeling?

1079

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

953

Is there any difference in testing database and data ware housing?

2696

Explain me what are conformed dimensions?

950

What is a full backup?

910

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1000

What is a functional dependency f said to be minimal?

983

Explain why are oltp database designs not generally a good idea for a data warehouse?

975

How to pivot data using informatica when you have variable amount of pivot rows?

860

What is the difference between metadata and data dictionary?

1063

Compare and contrast aggregates & indexes

3721