DSXchange

Hi,I am junior developer and have problem.I have source data like above.Credit_id is increasing automatically credit_id proposal_id 1 1 2 1 3 1 4 2 5 2 and i want to put this data to target like this credit_id proposal_id credit_index 1 1 1 2 1 2 3 1 3 4 2 1 5 2 2 how can i do? thanks for your helps

and also in the target there is only two empty columns are getting created , no data will be there ,status of the job is 2 rows processed.

Mahesh, The first 4 bytes are probably what's known as the "Block Descriptor Word", which can describe how long the block of data containing records is. In this case it was empty (all zeros). The next 4 bytes are the "Record Descriptor Word", which describe the length of an indi...

I dont have any layout or cobal copy book ,but i should run that hexa file through CFF stage line by line. myself only create the RECORDs data. Here i mentioned first record level number=2, native type is varchar and length is 5,second record level num=2,native type is varchar and length is 80. when...

Hi chulett , in the schedular options like today ,tommorow , every ,next and daily... when u select every means it will run every selected dates or days conyinuesly, but i want to skip one month between one month. for example my job run at 1st april 2011 next that same job will run at 1st june 2011....

Hi Ray ,
My job will run once at every two months ,how can we schedule like this for our job.

That means no need to enter in to the control-m, from the director only we can remove previous schedule and create new schedule for the jobs. and through director i can not abale to schedule a job in next month, i.e. in director scheduler view shows only current month. how can i schedule a one job a...

Hi All ,

How to create surrogate key through transformar stage with out using surrogate key stage.

Hi all ,

Requirment is to schedule the jobs in DataStage. Now they are using Control-M tool for scheduling but Control-M license has expired so now I should schedule those jobs through DataStage .

I am not trained on control-M tool. Can any one explain to me how to do this?

Thanks in advance.

Tnx ray...

In the table definations, what should i select as a delimeter for .csv file.

How to convert the hexadecimal file which is comming from mainframe side into in ascii format

ray.wurlod wrote:No, because there aren't any. You're probably better off using a Sequential File stage (possibly with a fixed record size). ...

Sequential file ..is it have capability to extract that type of file ,
if will i use as fixed record and the how to split that data into rows.

Hi ALL , tnx for u r Valuable replays

I am very new to this type of hexa decimal files.

Can any one please provide me some links to get more knowledge on extracting of hexadecimal files through CFF.

First you'll need to clarify for us what exactly it is you mean by a "hexa decimal" file. :? I have data like this in hexa decimal file. i that which is i mentiond under line that should be skipped and which is in bold that will be as a single row and which is represent as italic that sho...

Hi all,

How to extract the hexa decimal file through data stage px and
How to convert that hexa decimal file into txt format.