how can we perform the 2nd time extraction of client
database without accepting the data which is already loaded
in first time extraction
how many rows sorted in sort stage by default in server jobs
What are the different plug-ins stages used in your projects?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
Name the different types of Lookups in Datastage?
What is a quality stage in datastage tool?
1)Source file contains one record, I want 100 records in target file.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Difference between the Sequence and Sequencer in DS?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
What are the partition techniques available in your last project?
What all are the different way to run a job?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?