Answer Posted / kiran
First we Know about Seq file and Dataset.
Seg file is used Extract the from flatfiles and load into
flatfiles and limit is 2GB
Dataset is a intermidiate stage and it has paralism when
load data into dataset and it inprove the performanece.
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
What is job control?
Where the datastage stored his repository?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Can you explain how could anyone drop the index before loading the data in target in datastage?
how to abort the job its matain duplicates?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are transforms and what is the differenece between routines and transforms?
What are the benefits of datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What steps should be taken to improve Datastage jobs?
How to manage date conversion in Datastage?
Define Routines and their types?
What is the difference between Datastage 7.5 and 7.0?
How will you move hashed file from one location to another location?
What is the purpose of pivot stage?
