Interested to Buy Any Domain ? << Click Here >> for more details...
can a fact table contains textual information
- 6 Answers
- 14434 Views
- HCL, HCL BSERV, IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh
ANS: We can put textual information but not useful, actually
in FACT table, in contains numeric value for calculating
measurement like sales, profit/loss, revenue, date/time,
production, stock etc. in Fact table, it contains foreign
keys for maintaining relationships and measures for
analyzing the business as week/ month/quarter/year etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe the main features of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Why do we use link partitioner and link collector in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Define data aggregation?
What are the components of datastage?
What are the different plug-ins stages used in your projects?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the components of ascential data stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is size of a transaction and an array means in a datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the different options associated with dsjob command?
