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



How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size a..

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

Post New Answer

More Informatica Interview Questions

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


What are the restrictions of union transformation?

0 Answers  


What is a poling?

2 Answers  


What is a transaction control transformation?

0 Answers   Informatica,


what is $$$$?

0 Answers   TCS,






what is flat file override?

1 Answers   Cap Gemini, HP,


What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,


In which circumstances that informatica server creates Reject files?

2 Answers  


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

9 Answers   Deloitte,


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...

1 Answers   Cap Gemini,


How does the session recovery work.

1 Answers  


How to update records in Target, without using Update Strategy?

3 Answers  


Categories