DSXchange

you cannot pass job parameter to buildop

Hi, My requirement is to read the lines of data sequentially from the source file. My source structure would be like following: STARTMSG..........<msg_id1> 1.----------- 2.----------- 3.----------- 4.----------- 5.----------- STARTMSG..........<msg_id2> 6.----------- 7.----------- 8.----------- 9.--...

yes.....................splitting of stage variables will take time to compile.......

is dis regarding the availability of source file or is it regarding the presence of data in the source file....................if u want ur jobs 2 run only wen ur source file is present den it is possible..................r if it is like u wanna run ur job only wen a populated source file is present...

Hi, Even if ur file is .dat, dats not at all a problem........U can still go ahead n follow d things Arindam Banerjee has said above...........In d Sequential file stage, add d necessary columns, set the file name. Go to Format tab. Final Delimeter is end. In Field Defaults, check whether the Delime...

There is a property at sequence level in the job parameters "ADD CHECKPOINTS SO SEQUENCE IS RESTARTABLE ON FAILURE" which when checked will help you to make the sequence restartable. If this option is not checked in your sequence, please check it and then try running it. If your job gets a...

how much adviceable is it to perform a sort or a partioning before joining the records from sources. my record count is really high and its a production system i m dealing with.

in datastage for languages other then english please check the "UNICODE" from the extended type. this helps to get know the data better if it is anything other than english