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 |
What are parallel querys and query hints?
what is diff b/t sorter t/r and agg have the option sorter property...
How many mapplets u have created? and what is the logic used
What is a node in Informatica?
sample mappings for scd1,scd2 and scd3
update strategy transformation in informatica
How can yoU create or import flat file definition in to the warehouse designer?
What is deployment group?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
what is difference between mapping and mapplet ?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Types of error logs in Informatica?