iam new to datastage...now i want to know what are fact
tables, dimension tables in bank domain...if any body knows
plz tell me asap..
Answer Posted / bhargavi
Facts are numeric values (or) daily transactions done to any
business.
Dimensions are detail information about business
E.g.,: cust no,customer name,addr...
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of pivot stage?
How do you import and export data into datastage?
What is size of a transaction and an array means in a datastage?
What is the difference between an operational datastage and a data warehouse?
What are the differences between datastage and informatica?
What are the areas of application?
Name the different types of Lookups in Datastage?
Name the third party tools that can be used in datastage?
How to find value from a column in a dataset?
Enlist various types of routines in datastage.
What is ibm datastage flow designer?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How many areas for files does datastage have?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?