how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
Answers were Sorted based on User's Feedback
Answer / gm
You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abc
I think use the constraint load order and target load order
plan
| Is This Answer Correct ? | 0 Yes | 1 No |
what is degenerated dimension?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
How the facts will be loaded? explain
What is the difference between Bitmap and Btree index?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
What is enterprise data warehousing?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
What is depict expression change?
scenario where i can use only concurrent execution of workflow.
what is correlated query?