what is time dimension? and how to populate time demension
Answers were Sorted based on User's Feedback
Answer / vijaya
Hi
Every DWH has time dimension u can load the time dimension
though pl/sql script.
| Is This Answer Correct ? | 7 Yes | 2 No |
how to call routines in stages?
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
Define Job control?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
how do u reduce warnings
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
What are the areas of application?
how many write modes are there in ds
What are the different plug-ins stages used in your projects?