Interested to Buy Any Domain ? << Click Here >> for more details...
what is the architecture of any Data warehousing project?
- 5 Answers
- 20790 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / praveen kumar
step-01------>source to staging
step-02------>staging to dimension
step-03------>dimension to fact
This is the general procedure.........
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How is union transformation utilized?
What is joiner transformation in informatica?
What is the session task and command task?
What are Dimensional table?
Where do we use mapping variables in informatica?
What is workflow? What are the components of workflow manager?
What are the tasks that can be performed using sq?
What is flashback table ? Advance thanks
what is degenerated dimension?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the difference between router and filter?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
