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 can we create rank using datastage?what is the meaning of rank?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what is time dimension? and how to populate time demension
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
How do you design PX Routines ?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
can we use sequential file as a lookup
What is the difference between validate and compile?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
What are the different options associated with dsjob command?
Define Data Stage?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?