Give example for FACTLESS FACT TABLE in real-time scenario.
Answer Posted / satyam
genarelly fact table contains keyvalues and mesures products like that,fact less means it contains measures only so example in real time %discount,student monthly %of attendence like that ok,i think its a right once according my knowledge
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is datastage engine?
Nls stands for what in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the project in datastage?
What are the partitioning techniques available in link partitioner?
Difference between data warehousing and olap?
What is the process of killing a job in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the types of containers and how to create them?
What is the difference between account and directory options ?
How to clean the datastage repository?
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is difference between symmetric multiprocessing and massive parallel processing?