DSXchange

Ray, Thanks for your quick response. I need to check if the current date is first monday of the month in the job sequence . If true then start rest of the sequences else exit and send notification. I am able to achieve using the routine DSguru2B posted. If i understood your post correctly, you are s...

I need to identify "first Monday of the Month" . Found below post very helpful http://dsxchange.com/viewtopic.php?t=100700&highlight=&sid=6bc275df2574a955f3a90e2774003db1 DSguru2B - Your post was helpful . Your routine worked for me only when i removed the UPCASE out of the variabl...

Happy New Year :D

Deva,

I agree with DSguru2B and chulett.

Deva, I truly did not follow your requirement. Where did you store the result of the concatenation at first place(PART1,PART2....) ??? Is this result set source to another logic ? Where are you trying to achieve range of values between PART10 and PART30. Please give some details of how and what shou...

Please read Designer Client Guide . You will get the answers.

concatenate them as below in the transformer .

"PART":KeyMgtGetNextValue('ID').

Do exact Search on "AddMonths routine" ,you may find some ways to achieve your requirement.


Paddu

Thanks a lot .


Thanks
Paddu

Looks like it is german character What is your source system ? check the NLS settings in the source and target database using select * from V$NLS_PARAMETERS. Try to match the NLS setting of Datastage server with that of database while loading. Our seniors in this forum can throw more light on this. ...

Tables are not partitioned.

i did run the loads using BUlk load stage.showed good performance.

But i was trying to do multiple instances running files parallely using OCI stage.

.

I wish i could do that but the files we have are more than 30 million each . so if i have a partitioned table , do i have to pass any paramters for parition or when i kick off the multiple instance job , it basically goes an picks a parition for each process ( for each file load). Am i understanding...

Space could be an issue . we had similar kind of issue .Jobs used to run fine and suddenly we had issues opening a job , director gets hung. if you have access on the server ,check the free space. in another scenario i have seen this happening using Remote desktop connection. where i used to see err...

Minhajuddin , thanks it worked . i am testing the logic using only with 2 source files . the first file is loading very fast but the second job is really slow. infact the second job is not loading into oracle but waiting to load. After the first file loaded the second file is loading successfully . ...

creating a job sequence to run 5 files usinh the same job to load into single table used 5 job activity stages in job sequence . gave different filename in the each job activity.gave different invocation ids to each job activity. the job activity stage still needs soem information . it still has the...