Answer Posted / krishna
a dimension table contains the master data pertaining to a
subject area. this table is referenced by the fact table
when it is loaded.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is informatica?
Is there any way to read the ms excel datas directly into informatica?
What is a repository? And how to add it in an informatica client?
How do you change a non-reusable transformation to reusable transformation?
Differentiate between reusable transformation and mapplet.
Describe expression transformation?
Enlist the advantages of informatica.
During the running session, output files are created by informatica server. Enlist few of them.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain sessions. Explain how batches are used to combine executions?
How you prepared reports for OLAP?
Target increases every day even though no new record was inserted
What are the differences between source qualifier and joiner transformation?