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

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

Question Posted / davankumar

Answer Posted / davankumar

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by worklet?

1112

Informatica settings are available in which file?

1034

Explain the etl program with few examples.

1108

Differentiate between sessions and batches?

1062

Enterprise data warehouse your projects phase by phase explain?

1962

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1160

Explain why we use partitioning the session in informatica?

1157

What is rank index in rank transformation?

1125

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1837

What is informatica metadata and where is it stored?

1037

What are the types of presistent cache in look up tr.

2104

Slowly changing dimensions, types and where will you use them

1767

What is the use of transformation?

1050

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2120

What is the need for an etl tool?

1096