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 |
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
What are the restrictions of union transformation?
What is a poling?
What is a transaction control transformation?
what is $$$$?
what is flat file override?
What's the layout of parameter file (what does a parameter file contain?)?
In which circumstances that informatica server creates Reject files?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
How does the session recovery work.
How to update records in Target, without using Update Strategy?