What are the challenges of Dataware housing in the future?
Answers were Sorted based on User's Feedback
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 |
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Where should yoU place the flat file to import the flat file defintion to the designer?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
Can you copy the session to a different folder or repository?
What is synonym?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
what are the Methods For Creating Reusable Transformations?
What are the modules in Power Center
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
what is data driven?
what is shared Cache. when we will use shared Cache?
Diff b/w ShortCut and reusabel Object ?