What is factless fact schema?
Answer / mln
The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure
| Is This Answer Correct ? | 5 Yes | 4 No |
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
What is Micro Strategy? Why is it used for?
What is target update override
What are roles and groups and benefits of using them?
What is sq transformation?
who to split dimentions into sub dimention
What are the restrictions of union transformation?
Why the workflow is failed after running two hours in informatica?
What are the different types of olap? Give an example?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??