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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Performance tuning in UNIX for informatica mappings?
Define filter transformation?
What is a joiner transformation and why it is an active one?
is it possible to index the data in cache of lkp transformation ?
How does a sorter cache works?
What is a passive transformation?
Explain the features of connected and unconnected lookup.
Explain the etl program with few examples.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Can we create a Integration service without a Repository service and vice versa?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the different transaction levels available in transaction control transformation?