what is advantages of snowflake when it is used?
Answer Posted / sudhakar
the main disadvantage of snowflake schema is its normalised
format, so performance is poor and it is complex.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is use of SDR function?
How many types of hash files are there?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is oci?
Have you used Unstructured data?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the flow of loading data into fact & dimensional tables?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the purpose of pivot stage and types of containers in datastage
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is use Array size in datastage
Explain usage analysis in datastage?
What is quality stage?
What are the primary usages of datastage tool?