What are the challenges of Dataware housing in the future?
Answer Posted / krishnakanth.ch
I think as we move into the future, the historical data
size increases which impacts the performace for complex
calculations or aggregations. Which also impacts at report
level to drill down.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the complex transformation you used in informatica
What is domain and gateway node?
How an expression transformation differs from aggregator transformation?
What is a filter transformation and why it is an active one?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain in detail scd type 2 through mapping.
What are different types of transformations available in informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Differentiate between a repository server and a powerhouse?
How do you migrate data from one environment to another?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can u generate reports in Informatica?
How many number of sessions can one group in batches?
I have a flat file, want to reverse the contents of the flat file
tell me about your project functionality