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..
Answers were Sorted based on User's Feedback
Answer / 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 |
Facts in Banking
Account no
Dimensions in Banking
Branch
Amount
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / saikumar
Fact Table: it contains all the transnational Data of the customer
eg: deposited date,withdrawn date etc...
Dimensional Table: it contains non-transnational Data of the customer
eg: c.city,c.loc,c.cname etc.
Is This Answer Correct ? | 0 Yes | 1 No |
What is the process of killing a job in datastage?
What is a quality stage?
I have a few records just I want to store data in to targets cycling way how?
What is the differentiate between data file and descriptor file?
how to validate the jobs
How to reverse the string using unix?
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Is there any possibility to generate alphanumeric surrogate key?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How do u convert the columns to rows in datastage?
What are transforms and what is the differenece between routines and transforms?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?