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 |
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
What does update strategy mean, and what are the different option of it?
what r the transformations that r not involved in mapplet?
why we use informatica in our project?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Difference between Data and Index Caches?
Explain how to import oracle sequence into informatica?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
What is a grid in Informatica?
What does role playing dimension mean?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS