What is the approximate size of data warehouse?
Answer Posted / jeevankumar medapati
smal projects:::100gb to 500 gb
medium projects:: 500gb to 1000 gb
large projects :::1000 gb to 1200gb etc
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
can u any challenge your project?
How we can create indexes after completing the load process?
Explain in detail about scd type 1 through mapping.
What is an Integration service in Informatica?
What is a repository manager?
Define mapping and session?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain the mapping variable usage example in informatica
What are batches?
What are junk dimensions?
where to store informatica rejected data?