In my previous project we get data from mainframe and load it
into datastage DB2 tables.Sometimes we get data as flat file
or a mainframe tables itself directly we fetch the data.Is
this a migration project?
Answer / sarath
We can not say this is/isnt a migration project based on your query.For many projects we get the data from mainframe or as flat file
Migration project means the entire code is developed in one technology ( lets say eg: SAS) and now they want to implement the same code in new technology ( say now DATASTAGE) for better performance. as it will take more time to complete the job in SAS compared to datastage. finally the goal is optimization.
Is This Answer Correct ? | 0 Yes | 0 No |
how to identifie,is it innerjoin,leftouter join in lookup?
How to Convert the columns into rows?
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)
how to abort the job its matain duplicates?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Can you explain engine tier in information server?
Define repository tables in datastage?
What is apt_config in datastage?
how to convert rows into columns
what is flow of project?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.