DSXchange

Hi,

I have to design a process and run it for 5 different NLS settings.
The standard approach is to have 5 different job designs, 1 for each NLS setting.

Can we in some way parametize the NLS setting or develop a job design so that only 1 job can cater to all NLS settings.

Please suggest.

Thanks
r

Hi,

I am sorry for that. Will use formal English on the forum now.

yes am logged in as the same user in Director. I was facing the same problem in a previous project too where I used the at command to check the scheduled jobs.

Thanks
r

i am sorry i checked again. i was using a different user id to check form command line. Actually i just joined this project today so got alittle confused with the userids n pwds. I can now see the scheduled job when i check thru at -l. can u also plz help me out on why am not able to see the schedul...

yes. i'm checking using the same user to check from command line.

Thanks
r

Hi, I am trying to schedule jobs through the director. When I schedule a job that needs to be run daily or weekly then i can see it in the director. When i am trying to schedule the job for 1 single day then it does not get scheduled in the director but the job runs at the scheduled time. After sche...

Dear all,

I need info abt plugin stages in Datastage. Plz help me with this.
Also it would be nice if someone can suggest some links or references on
this. Its urgent.

Thanks in advance
r

hi, i have to perform multiple lookup. i have a source file of the form: key origin country trans country destination country All the 3 country fields contain country codes The reference file contains country code & country name. i perform a lookup using the above method. But after the lookup al...

hi , i was having problem with surrogate key stage. I am having a failed validation while using a surrogate key generator stage.The error that is specified is Surrogate_Key_Generator_1: One of these must be provided: Surrogate_Key_Generator_1: -schema Surrogate_Key_Generator_1: , Surrogate_Key_Gener...

hi,

where can i get documentaion for pivot stage. i cannot find it in parallel job developer's guide of DS 7.1

when i use line feed the output is as follows: 1|One|2|Two|3|Three2|Two|3|Three|4|Four|

when i use carriage return, the output is as follows:
1|One|2|Two|3|Three|
{spaces}2|Two|3|Three|4|Four|

the problem still exists.

Regards
r

hi, Please help me out. i have a reference file of the following type. 1st_char f1 f2 f3 f4 f5 f6 f7 prod_code D - - - - - N - RB D - - - - - - - RD A - - - - - - Y RJ A N Y - N - - - RH A - Y - - N Y - RF W - - - N - N Y RK . . . there is no unique key. based on the 1st char & the values of the...

hi, i am new to datastage. i was trying out this solution provided by Matthieu & i'm facing a problem. plz help me out. to convert the transformed file back to its original form, i used 2 stage variables, StgPrev & stgCurr for storing previous & current values of the Surrogate key & ...

hi,
i have to extract the schema of all input and output files. is there some way i which i can do it at command line instead of searching for the files in the xml generated