In dimension and fact table? which one holds big data?

Answers were Sorted based on User's Feedback



In dimension and fact table? which one holds big data? ..

Answer / ravikumar2614

Fact table having huge data with less colomns..

Is This Answer Correct ?    2 Yes 0 No

In dimension and fact table? which one holds big data? ..

Answer / davankumar

Fact table has the big data bcoz fact table main tain
history data.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to handle decimal places while importing a flatfile into informatica?

0 Answers  


which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


What are the new features of the server manager in the informatica 5.0?

1 Answers  


i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,


Can you generate reports in Informatcia?

1 Answers  






Why we use partitioning the session in informatica?

2 Answers  


in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,


how can you load data into target table without leading zeor's

4 Answers   Deloitte,


create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,


In informatica workflow manager, how many repositories can be created?

0 Answers  


what is the flat file partition and where have to specify it

1 Answers   TCS,


can you avoid static cache in the lookup transformation? I mean can you

1 Answers  


Categories