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
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the purpose of pivot stage?
Difference between server jobs & parallel jobs?
What is the importance of the exception activity in datastage?
What are stage variables and constants?
What is difference between server jobs & parallel jobs?
What are the different kinds of views available in a datastage director?
What is the difference between server job and parallel jobs?
Can you explain link buffering?
Which warehouse using in your datawarehouse
How do you import and export the datastage jobs?
Name the command line functions to import and export the DS jobs?
What is the different type of jobs in datastage?
What are the steps required to kill the job in Datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks