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 / subhash
FACT Table:(Daily transaction details)
Transaction_Details
Dimension Tables:(Which have static data)
Customer_details
Account_Details
DATE & TIME
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you explain tagbatch restructure operator?
Can you explain engine tier in information server?
Notification Activity
What is the differentiate between data file and descriptor file?
explain about citrix scheduling tool in datastage
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the process of killing a job in datastage?
How do you reject records in a transformer?
Explain entity, attribute and relationship in datastage?
What is usage analysis in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Can you explain players in datastage?
State the difference between an operational datastage and a data warehouse?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?