Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 25230 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is enterprise data warehousing?
How can we use mapping variables in informatica? Where do we use them?
What are Dimensional table?
How do you migrate data from one environment to another?
How to convert multiple rows to single row (multiple columns) in informatica
How do you take back up of repository?
What are the mapping parameters and mapping variables?
How to elaborate tracing level?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is standalone command task?
What is data caches/ index caches?
Write the unconnected lookup syntax?
