DSXchange

Hi all, I have a configuration file with 4 nodes and I set it up in Administrator. In my job , I am using a special token $PROJDEF as a default value for the Configuration file. Now I want to constraint the Sequential file stage in my job to run it on a single node. But I am getting a message in Seq...

Thanks for the reply chulett.. I am marking this topic as resolved..

Sean

HI All, I am running a job in which it loads about 35million rows into an Oracle table. My job aborted in the middle after loading around 20 million rows.. I wonder is there any chance that i can start the job from the point where it stopped? or do I need to manually delete the rows from the table a...

Hi all,
I am loading the data into an oracle table using Oracle Enterprise stage and I set the $APT_ORAUPSERT_COMMIT_ROW_INTERVAL to 2000 rows for the first time. Is it possible to change the number of rows to commit to 3000 in the next load during runtime?

Thanks in advance
Sean

Use the Sort Funnel type and specify the first column as a Key.

Sequential Funnel combines the data sequentially from the first file , then the second file and so on.


Sean

I don't know whether you really tried or not becuase this is very easy. Please search the forums for more information on stage variables. I am sure you will find thousands of posts. Since I had done this before, here is what you are looking for svCurr : Src.Col1 svUni : If svCurr = svPre then 'Y' el...

got it. Thanks Chulett.

Hi , Is there a way to reset the surrogate key sequence that is generated by SDK routines to starting point again once it is run? My opinion is that it is not possible to reet any sequence that is generated using SDK routines to zero.. Please advice. I did searched for it in the forums but did not f...

You can use DS functions in the transformer to get the number of rows from a input link. GetLinkInfo(). Using system variables like @INROWNUM , you will get the number of row that you are inserting/updating or the row that is rejected. If you want to see the total number of rows inserted , then chec...

Because OraOCI stage is the native stage available for connecting to Oracle database. The performance is faster with the OCI stage than using ODBC stage. As Chulett mentioned, ODBC stage is used only in a case where native Database stage is not available.

As Chulett said, you can use substr to get the date only from the input format that you have mentioned. Else you can use built in transform TIMESTAMP.TO.DATE along with either OCONV function or DATE.TAG to get the date only from the timestamp. Note : The input date format must be 'YYYY-MM-DD HH:MM:S...

Ray, Thanks for your reply. may be the question that I posted is not clear. Lets say I have a Copy stage with one input link and 4 output links . Now without changing the job design , Can I limit the number of output copies to 3 during runtime from the COPY stage?? Once again, I appreciate your help...

Well, I m not sure of your question but if you are asking about Stream link , Reference link and reject link, then here you go. Stream link is used for source files or master files while the reference links are used for Lookup files and Reject links are used as the name suggests rejected data. You w...

Hi, I am using the Enterprise edition for the first time and I want to know how to send dynamically the number of output files that we want to create or copy using the COPY stage in Enterprise edition. I did a search for this but did not find anything about this. Any help can be greatly appreciated....

XP is not a supported Server platform??? thats not true..

DataStage can be installed on XP and there is no problem with the OS. May be I am missing something which I dont understand.
Any help can be appreacited...


Thanks
Sean