Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / venkateshmalneni
A fact table is multiple of combination of dimension tables
ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores
3*365*200*200=fact table size
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Where can we find the throughput option in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Informatica settings are available in which file?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
list out all the transformations which use cache?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain lookup transformation source types in informatica
Different sorts of metadata that stores in the storage facility?
What are the types of data warehouses?
What is the surrogate key?
What do you mean by blocking transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is the size of u r source(like file or table)?
