DSXchange

Hi, I am using the Execute Command stage to run the job as below Command: dsjob Parameters: -run -mode NORMAL -param SEQ_ID=#StartLoop_ID.$Counter# TEST testjob.#StartLoop_ID.$Counter# But, job didn't started. Please find the log below. Executed: dsjob -run -mode NORMAL -param SEQ_ID=1 TEST testjob....

Hi All, I have 60 mln records in source and want to split (based on rownum)and process them with multi instance job in the Sequnce job with loop (12 times). For each instance, i would like to take 5 mln rows . My database is Oracle10g. Is it possible to split the records based on instance and rownum...

ray.wurlod wrote:There's no looping within the Transformer stage until the next version. ...

Hi All,

Thanks for your inputs.

Is there any other way to implement it (if not in DS)?

Thanks in advance.

Are you updating Table A with runn_bal - rem_amt always? I should update it...Or we can hold it in a variable until it reaches 0 and then update it. Can you give better example for what do you mean by loop? Hi anbu, I don't know what to call it....so called it as loop..... The reason being...first ...

ray.wurlod wrote:Looks like you need to source a Cartesian product of A and B.

How is Status determined? ...

Thanks Ray..


For Table A....as soon as it reaches 0.change the status to 1.....

For Table B.....as soon as you read the record change the status to 1..

anbu wrote:Are you updating Table A with runn_bal - rem_amt always?

I should update it...Or we can hold it in a variable until it reaches 0 and then update it.

Hi All, My requirement is as below...... First get a record from Table A and then get the record from Table B and do the runn_bal - rem_amt. If runn_bal - rem_amt <> 0 then update the runn_bal with runn_bal - rem_amt an Table A , and get the second record from Table B and and do the math again...and...

Hi, I am trying to Read and Write to same sequential file (i am overwriting the sequential file on Target side). But it fails as it is not reading from the file. But my observation is, if i change the filename on the target side it is reading data from the file and writing to new file. Any help woul...

Hi, My Input file has some special characters. I have used the HEX editor to find out them and they are (OD OA pairs) and HEX (00). I want to replace them with the spaces. I have gone thru the forum and found some solutions like 1). EReplace and Iconv with MCP 2). EReplace( string,char(13):char(10),...

Hi Anand, I have created new user and password at OS level. Then I have created user as specified above. For that user I have assigned the Suite Administrator and suite user and under suite component i have selected all. With the above user i can login to web console and console but not the any of t...

My laptop does have default username and it doesn't have any password.
Should I create a password now and assign it to the users.

Or Do i need to re-install whole thing after creating user again.

Thanks in advance.
naren.

Hi All, By using the above method , i have created a user but not able to login to the designer client. The error message is : Failed to authenticate the current user against the selected domain. Could not connect to server [computer name] on port 9080. I even tried with localhost:9080 as the Domain...

Type http://localhost:9080 and check that you are getting Information Server loin page. If it fails to show then check that below services are running or not: 1) IBM Websphere Application Server V6---- 2) All the Db2 related services if the meta server is installed on DB2. Just check and revert Tha...

Hi, I have Installed the V 8.0.1 (Engine and Client) on Windows XP Pro machine. When I tried to open the Web console it gives me an error saying "the page cannot be displayed'. Please shed some light on this as and how to configure the V 8.0.1 on win XP. Thanks in advance. Best regards, Naren

Hi, The database is DB2. My requirement is If the first 6 characters of RECORD_ID = LOC_ID then get the REGION_NAME from LOC_INFO table. If you are not finding some of the records then fall back would be to compare the first 3 characters. I wrote a query as below, but erroring out with the following...