Interested to Buy Any Domain ? << Click Here >> for more details...
why dataset ?
- 2 Answers
- 5997 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas
Dataset is a file which can be used for stored data as intermediate result.
Compared to other files processing is fast by using the Dataset because its internal format is DataStage support format.
Most of the times we can use this as intermediate data storage.
One added advantage is node system we can use multiple nodes
in dataset.
We have lot of uses by using this file dataset.
In server edition we have hashfile same way in parllel edition we will use DataSet.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What is the default execution order of the sequential file?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
What is active and passive stage?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
How you Implemented SCD Type 1 & Type 2 in your project?
What is the different type of jobs in datastage?
How can we achive parallelism
Can you implement SCD2 using join, transformer and funnel stage?
Teradata 
