Interested to Buy Any Domain ? << Click Here >> for more details...
Do you have knowledge in ralph kimball methodology
- 1 Answers
- 3626 Views
- I also Faced
- E-Mail Answers
Answer / isha
Ralph Kimball's dimensional design approach (the bottom-up design): The data marts facilitating reports and analysis are created first; these are then combined together to create a broad data warehouse. Inmon defines data warehouse as a centralized repository for the entire enterprise.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the main issues while working with flat files as source and as targets ?
what is lookup ?
how to duplicates from expression transformation without using sorter before that
what is the difference between onsite & client site?
How to differentiate between the active and passive transformations?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
How many ways are there to create ports?
What is the need for an etl tool?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
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
Teradata 
