Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vas.chiky
Having separate OLAP DWH database for analysis, increases
the performance of reports.
even during backup or crash period of oltp, OLAP database
will not get affected.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
What is sorter transformation?
how many types of dimensions are available in informatica?
What is the difference between router and filter?
Define mapping and session?
What is lookup transformation?
To import the flat file definition into the designer where should the flat file be placed?
Write the unconnected lookup syntax?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to load a Dimension ? and how to load a fact table?
what is degenerated dimension?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differentiate between Load Manager and DTM?
What are the different versions of informatica?
Explain the different lookup methods used in informatica?
