How do we do the Fact Load
What is the size of your Data warehouse?
What is your Daily feed size and weekly feed size
Answer / rameshreddy
After dimension load takes place we can load the Fact tables.
and
size of data warehouse for small projects 100-500gb
medium projects 500-1000gb
large projects 1000-N gb
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain the features of connected and unconnected lookup.
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
what is datamart
why we use materialized view over view?
What is informatica? What exactly are the practical uses in real world
How can we update a record in the target table without using update strategy?
what is the difference between informatica6.1 and infomatica7.1
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
In which circumstances that informatica server creates Reject files?
Define mapping and session?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
TELL ME ABOUT WORK FLOW SCHEDULING?