Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse

Question Posted / sri

Answers were Sorted based on User's Feedback



Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / ranjan

it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .

Is This Answer Correct ?    17 Yes 2 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / abhishek

ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table

Is This Answer Correct ?    10 Yes 0 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / rajupatel

Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH

Is This Answer Correct ?    10 Yes 1 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / dhana

Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks

Is This Answer Correct ?    0 Yes 0 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / bsgsr

hi, raju patel.

ur answers are thoughtful. they reflect ur intellect which
is very stimulating and vibrant. i am pretty impressed with
your answers.

i believe you have good experience with the industry. since
when have you been working with the industry. can i have
some of my queries cleared only if you dont
minddddddddddddddddd!!!!!!!!!!!!. revert back to me on my
id bsgsr12@gmail.com also provide me your number if you
dont mind. take care

Is This Answer Correct ?    1 Yes 10 No

Post New Answer

More Informatica Interview Questions

any body can say about all versions of informatica ?how many versions ?

2 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

How can you join two tables without any common column present in them?

1 Answers   TCS,

Why do we need informatica?

0 Answers  

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

Briefly explain the aggregator transformation?

0 Answers  

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

how i will stop my workflow after 10 errors

1 Answers   HP,

For more Informatica Interview Questions Click Here
Categories