DSXchange

Hi I need help to create sequence number. Actually my input is Sequential file and output is oracle table.The file has 750000 records. I used surrogate key generator stage.generated sequence number first time.But i will get the input file every week.so i need to load every week. now my output key co...

Thanks for you reply ArndW

ArndW wrote:You won't get a timestamp unless your format string matches your data. Try formatting with '%yyyy%mm%dd %hh:%nn:%ss' and making sure your input string also has a dummy time part added to it.

i.e. [ ...

I am facinig some problem with Conversion of string to timestamp my input is Sequential file and i am loading(Append) data into existingOracle table. Seq--->Trans----> Oracle Table I am not able to view the date.. I am getting warning like : Transformer_1,0: Conversion error calling conversion routi...

Thanks for your reply
I don't know where can i find this oracle log..

Please let me know if you have any idea..

Thanks.

ArndW wrote:And what does the Oracle error log file contain? That will tell you exactly what happened. ...

Hi i am geting the follwoing error.Just i am loading the data from flat file to oracle table. Oracle_Enterprise_19,1: The system(sqlldr shrhlth/shared1@orcdbt CONTROL=ora.921628.154959.1.ctl LOG=ora.921628.154959.1.log BAD=ora.921628.154959.1.log.bad SILENT=header PARFILE=ora.921628.154959.1.par) fa...

Hi I am getting the following fatal error.If any one know about htis please let me know 1) node_node1: Fatal Error: Unable to start ORCHESTRATE process on node node1 (blubluds007): APT_PMPlayer::APT_PMPlayer: fork() failed, Resource temporarily unavailable 2) main_program: The Section Leader on node...

Its' just 3

swades wrote:How many possible value for type?It only just 3 or more?

The above data is from Sequential files.I want out put also seq.file Please give me Idea Hi I need some help about my logic. My input data is like below ID Type 1001 20 1001 20 1001 20 1003 20 1003 23 1003 20 1003 23 1010 20 1010 23 1010 20 1010 23 1010 24 1010 24 1010 24 1010 24 1013 24 1013 24 So ...

Hi I need some help about my logic. My input data is like below ID Type 1001 20 1001 20 1001 20 1003 20 1003 23 1003 20 1003 23 1010 20 1010 23 1010 20 1010 23 1010 24 1010 24 1010 24 1010 24 1013 24 1013 24 So 1.if same ID has Type only 20 then i need output of that all ID's of that 20 2.if same ID...

Thank you very much Rey

ray.wurlod wrote:1. Constraint expression (InLink.AAAA < 0) on output port #0.
2. Use stage variable to generate sequence and another to convert same to string which you can concatenate to your source string ("2 ...

Can any one give me idea? 1.if the field AAAA are negative the data field BBB should be mapped to CCC 2.I have one Sequential file.i need to transform the data like NUM field should be given unique number string at 22222 and should be unique from then. it should be increase in each row.ex 2222210 22...

Thanks for your quick response
I checked in server guide i did not find Command Line Interface . can you please give where can i find this.Or give me answer if possible.

DSguru2B wrote:Read the Server Job Developer Guide, specifically Command Line Interface. It will give you the exact syntax.

I am trying to run the job from command line.if i gave like dsjob -run -jobstatus projectname jobname it is working but it is taking default parameters. I want to pass different parameters from command line.there are four parameters.the parameters userid,password,database,path. How can i pass parame...

Permission issue of dsenv script.
I got permissions and the i ran the script.You posted like dot space dot then path. But we need only one dot space than path that i mentioned below..

. /dstage/Ascential/DataStage/DSEngine/dsenv

Thanks a lot.

DSguru2B wrote:What was the issue?

Thanks to all of you guys
Now it's working.

DSguru2B wrote:Ok. cd to the DSEngine. Check for execute permission on dsenv. See if you have it. If not then you need it. Once you get it. Try running the same command again.