can we see the data in fixed width file? how can u change
the datatype of fixed width files?
Answer / venkat
in seq file field width option is there we can change datatype and length
| Is This Answer Correct ? | 0 Yes | 1 No |
Why do we use exception activity in Datastage?
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
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)
Explain ibm infosphere information server and highlight its main features?
i have flat file and using unix how can i generate sequence number into targer?
In one project how many shared containers are created?
Define project in datastage?
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
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
Describe the main features of datastage?
How can we do null handling in sequential files?
how to find diff between 2 dates without using Icon... funtions?