how to sort two columns in single job in datastage.
No Answer is Posted For this Question
Be the First to Post Answer
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Explain how a source file is populated?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
How to display errors in datastage?
Define ds designer?
1)Source file contains one record, I want 100 records in target file.
Unix command to view the data in a dataset
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
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?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA