enterprise datawarehouse your project phase by phase
explain?
Answer / siva
Its depend on the project scheduling..
In some projects.. it will considered as
ph1 -- Requirements Gathering
ph2 -- Analysis and framework
ph3 -- Designing
ph4 -- Production Migration, performance tuning and
maintenance activities
In other hand some projects will be set as
ph1 -- Integrating the sources
ph2 -- Creating the Datamarts and Aggregations
ph3 -- Reporting
So its depends on size and requirements of the project
Hope you got it..
Is This Answer Correct ? | 8 Yes | 0 No |
Explain constraint based loading in informatica
Where is the cache stored in informatica?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
can u give example for factless fact table
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Implementation methodology
diffrence between command task and control task
explain abt joiner t/r?