DSXchange

It should not be any problem , just define all the tags properly and try to uncheck the initial validation option ... it will parse the file properly , datastage treats unavailable tags as optional tag and put blank in the respective column.

Regards

thanks Ray,


i haev already observe those things but here issue is shifting of values in different columns you can see the file is pipe delimeted and the values are getting shifted into the other columns.
why this shift and value termination is going no.


Help will be appriciated.

i am having one source input from file that records i have already pasted and having one normal lookup and from the same reference dataset there are 6 multilinks are coming for reference to same source dataset . source is the primary link and refrences are the secondry links in order they named. tha...

Hi,

i want to know why is this happening ? and how to stop this as i want data to be populated in the correct columns only.but i didnt get why this scenario is coming in picture .

Can some one help to resolve this issue.

hi Friends, i am running a simple parallel job having one input source and taking the multiple look up using the a single table. here if i am running the job then i found that in output file from lookup the column values are getting shifted into right and the shift is equal to the number of lookups ...

Thanks for the input Sir,

we have tried with sequencer and also with the multiple trigger from one success scenario , but the same result is coming out.

i need more of your valuable inputs.

check the trigger condition in the stages you might be wrongly calling the jobs one after another.

hi , we have a master sequence which will call the different interfaces in the same go using same run script but with the different instance id's. sequence is very simple its simply triggering the scripts stage. the interesting part is not all the script are getting triggered on the same time , but ...

Thanks keshav,

Yes you are right by this way we can go on...

Could you please tell us how it is possible in Server job....?


thanks for the guiding me...

thanks keshav,
yes u r right by this way we can go on...

can u please tell us how it is possible in Server job....

thanks for the valuable suggestions....

no the input meta is different but i need to combine the output in a single file with the common columns from the input files.

so is it not possible in a single job to read one after the other...???

input stages are seqfile stages and the data is normal business data ,i just want to check wheater it is possible to read the files one by one .
when ever i m trying to do the testing every time stages start reading on same time ... do i need to setup any constarints to achieve this result.

how to read multiple stages in datastage one by one

my req is like i have 3 input file stages with me , where i want to start reading the second input stage only when the 1st get over same for the 3rd when 2nd get over...

is this possible in data stage to di it in same job.

any way i am not the premium member so i can't see the full suggestion given by you...

thanks for the help provided...

but the scene is , why the job is getting aborted ? because in other cases like ora 1403 error of having duplicates on key or ora 1400 null insert error in keys job finishes smoothly without any aborts , why its happening in this case. friends its a strange way of dealing data by Data Stage or may b...