Interested to Buy Any Domain ? << Click Here >> for more details...
what is advantages of snowflake when it is used?
- 3 Answers
- 8346 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kishore
snowflake schema has normalized data i.e one dimension table
contains another dimension table like parent table and
child table
we can't get the data from child table directly i.e it
manitains secrecy
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is ibm datastage?
How to implement complex jobs in data stage?
What is the difference between server job and parallel jobs?
Difference between sequential file and data set?
What is the different type of jobs in datastage?
What are the types of hashed files in data stage
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Explain how a source file is populated?
How a server job can be converted to a parallel job?
What is the purpose of interprocessor stage in server jobs?
What is the flow of loading data into fact & dimensional tables?
How do you run datastage job from the command line?
