what is snow flack schema?

Answers were Sorted based on User's Feedback



what is snow flack schema?..

Answer / suresh

above answer is wrong,correct answer is converting denormalized data into normalized data is called snow flake schema

Is This Answer Correct ?    0 Yes 0 No

what is snow flack schema?..

Answer / srinu

one fact table is surrounded by different dimension table
and dimension table relation with master dimension table is
called snowflake schema (or) extended star schema

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Data Stage Interview Questions

Can you highlight the main features of ibm infosphere information server?

0 Answers  


How can we do null handling in sequential files?

3 Answers   Reliance,


What are the various kinds of the hash file?

0 Answers  


1)Source file contains one record, I want 100 records in target file.

3 Answers  


what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,






Define Routines and their types?

0 Answers  


Describe the architecture of datastage?

0 Answers  


How can we achive parallelism

1 Answers   CTS,


Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,


In which situations we can use normal and sparse lookup stages

4 Answers   IBM,


What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,


This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,


Categories