Answer Posted / siva
Fact table contains facts,measures or numerical vlues. Foe
example if your business process is 'sales' then a
measurment of this business process contains name of the
product,price of product,location and date and time of the
product sales.It also contains foreign keys of all the
dimension tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
Explain Dataware house architecture .how data flow from intial to end?
Explain about cumulative Sum or moving sum?
Please let me know how to make encryption and decryption with example?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the reusable transformation?
How can we use mapping variables in informatica?
What are the new features of Power Center 5.0?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to create the source and target database connections in server manager?
How many number of sessions can one group in batches?
what is unit testing?tell me proceedure
How to open an older version of an object in the workspace?
