| Other Data Stage Interview Questions |
|| Asked @
|My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
|How did you reconcile source with target?
|how can u connect the client system directly at any time?
|what is the best stage in datastage parller jobs to use full
out join and why
|IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS
THEN i SELECT perform sort ON eid,uncheck both
unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT
I CAN GET.what happend if i select UNIQUE,STABLE.
PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
|I have 100 records how can I load at a time from the single
|how can you generate sequence number using only the sequential
|what is the difference between the join and look up
explin me one exmple
|how to handle null values in sequential file?
|I am having two tables called MASTER and DETAIL. I want to
insert records to both tables. But one condition is that
whenever the insert for MASTER table is success then only
the records will inserted into the DETAIL table, otherwise
abort the job. How can u design this job?
|how to convert rows into columns
|what is meant by port ?
what is the use of port ?
what are the different type of ports and its usage
|For more Data Stage Interview Questions Click Here |