Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anju
Kimball: Data warehouse is combined of all the data marts
in an enterprise.Inofrmation is stored in dimensional model
Inmon:Datawarehouse is a part of business Intelligence
system. An enterprise has one data warehouse and data marts
source information from the datawarehouse.Information is
stored in 3rd normal form
Practically most of the enterprise data warehouses
following Ralph Kimball's methodology.Started as Data marts
and then evolve into data warehouse.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
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 is sequence generator transformation in informatica?
what is the -ve test case in your project.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the static cache and dynamic cache in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can you generate reports in informatica?
Explain the different dimensions.
How many transformations can be used in mapplets.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Partition, what happens if the specified key range is shorter and longer
Mention few power centre client applications with their basic purpose?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
