Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 8227 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
How you Implemented SCD Type 1 & Type 2 in your project?
What is meta stage?
What is Fastly Changing Dimension?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
How to convert RGB Value to Hexadecimal values in datastage?
detail about sdlc
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
Can you explain repository tables in datastage?
How do you run datastage job from the command line?
Teradata 
