Answer Posted / srinivas
hi friends,
this is right friends , bt oltp is current data. olap
maintains historical data for analyzing purpose.. olap is
read-only data. it is denormized data . it has dimession
table ,fact table data .
it has detailed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you handle two sessions in Informatica
What does role playing dimension mean?
What is joiner transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the use of an aggregator cache file?
How to elaborate tracing level?
What are data-driven sessions?
what is degenerated dimension?
What is the different lookup cache(s)?
Can we create two repositories on same database instance in oracle?
During the running session, output files are created by informatica server. Enlist few of them.
What do you mean by blocking transformation?
can u give example for factless fact table
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?