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

Question Posted / gangadhar799

2 Answers
6470 Views
I also Faced
E-Mail Answers

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

What is domain and gateway node?

0 Answers

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers

How do we implement materialized view?when to use materialized view?

1 Answers TCS,

Differentiate between joiner and lookup transformation?

0 Answers

how can u avoid duplicate rows in flat file?

4 Answers CTS, Wipro,

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers Cap Gemini,

What is a router transformation?

0 Answers

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers Wipro,

Differentiate between sessions and batches?

0 Answers

What do you mean incremental aggregation?

0 Answers

Separate from a database, an information bazaar, and an information stockroom?

0 Answers

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers SAIC,

For more Informatica Interview Questions Click Here