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 |
Could any one to tell Fact table Partitioning?
can anyone explain me about retail domain project in informatica?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
What is the reusable transformation?
what is work of PUSH DOWN option
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
what is the difference between repository & Intergration service
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
How to Join Tables my Source is having 15 table target is one?
What does role playing dimension mean?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?