what is snow flack schema?
Answers were Sorted based on User's Feedback
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 |
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 |
Can you highlight the main features of ibm infosphere information server?
How can we do null handling in sequential files?
What are the various kinds of the hash file?
1)Source file contains one record, I want 100 records in target file.
what is the diff b/w switch and filter stage in datastage
Define Routines and their types?
Describe the architecture of datastage?
How can we achive parallelism
Display all files which have size more 3KB in given directory/folder.
In which situations we can use normal and sparse lookup stages
What is difference between 8.1 , 8.5 and 9.1 ?
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)