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 |
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
how many rows sorted in sort stage by default in server jobs
What is a range lookup?
What is difference between 8.1 , 8.5 and 9.1 ?
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
What is container and then types?
How you Implemented SCD Type 1 & Type 2 in your project?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the areas of application?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?