Monday, March 7, 2011
What is Dataset in Datastage? Uses of Dataset ?
Dataset Supports 1 input link or 1 Output link and there will be no reject links in dataset stage.
Dataset will overcome the Limitations of Sequential Stage
By Default Dataset will processed parallely.
Dataset will stores the data in the Native Format.
Dataset will stores the data inside Repository ( i.e inside Datastage)
And It has memory of more than 2 GB ( > 2GB)
There are Two types of Datasets. They are
1) Virtual And
Virtual is noting but the data formed when passing the link.
Persistance is nothing but the data loaded in the Target.
Alias names of Datasets are
1) Orchestrate File
2) Operating System file
And Dataset is multiple files. They are
a) Descriptor File
b) Data File
c) Control file
d) Header Files
In Descriptor File, we can see the Schema details and address of data.
In Data File, we can see the data in Native format.
And Control and Header files resides in Operating System.
And we can organize the data by using Dataset Utilities
GUI( Dataset Management ) in Windows environment.
CMD ( Orchadmin) in Unix Environment.
If you know Better Answer for Above Question Comment below to Answer.
Change Capture Stage is used to capture the changes between two sources based on the change code. Change Code is the Code generated w...
Some times we get the data as below Customers 1,tommy,2000 2,sam,2300 3,margaret,2000 4,pinky,1900 5,sheela,2000 Take Job Design...