How do we do the Fact Load
What is the size of your Data warehouse?
What is your Daily feed size and weekly feed size
Answer / rameshreddy
After dimension load takes place we can load the Fact tables.
and
size of data warehouse for small projects 100-500gb
medium projects 500-1000gb
large projects 1000-N gb
Is This Answer Correct ? | 3 Yes | 0 No |
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How we can use union transformation?
Tell me about MD5 functions in informatica
Separate from a database, an information bazaar, and an information stockroom?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Write the unconnected lookup syntax and how to return more than one column.
Where should yoU place the flat file to import the flat file defintion to the designer?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
What is the benefit of partitioning a session?