Interested to Buy Any Domain ? << Click Here >> for more details...
what is snow flack schema?
- 2 Answers
- 6317 Views
- I also Faced
- E-Mail Answers
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 |
How do you load 10 different sources with 10 different layouts to 10 different tables?
how to find diff between 2 dates without using Icon... funtions?
what are fact tables and dimension tables? give example assuming one table.
How do you load dimension data and fact data? Which is first
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
How and where you used hash file?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
Why we use surrogate key?
plz tell me some dimentional and fact table names in banking project?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
Why do you need stage variables?
Teradata 
