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 |
Can any one explain or sujjest some sites for scd mappings.Thank you
What is the difference between lookup override and souce qualifier override ?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What are active and passive transformations?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Explain pushdown optimization and types in informatica
what is scd?
what happens if you try to create a shortcut to a non- shared folder?
What is query panel?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
how will you get 21 to 30 record from 50 records?
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance