DSXchange

Vinay,

Can you delete the merge file (created by previous run) before running the job and let me know what message you get. I suspect transformer might be reading incomplete data (even before the file is loaded) which, ofcourse, should not happen. Just want to make sure that is not the case.

- Nav

One setting you want to make sure is that the target stage's array size should be "1" if you want to capture the rows rejected by target.

If a row gets added in your DB2 every min, should you update your oracle table immediately? Or Can you accumulate rows, say, for 1 day and start your update process and update all the rows changed in that day?

As i said earlier..why not trigger the stmt in Database itself. Ofcourse, you cannot avoid Union with this approach. But what you can avoid is all the read and write operations that you are doing when you are fetching the data into the Datastage server. Have a sequential file with a single col (say ...

Ray, Just wondering what problems are you talking about. Can you please elaborate?

I thought CASE stmt can only be included in select list not as a part of your where clause. Am i wrong?

Didn't understand your requirement. Can you explain a little bit. Do you have to execute this Insert..select stmt on your taget database so your menu_record table gets loaded. Is that it? To do that you can trigger the stage with a single row, single col source which will fire this SQL on the Target...

Sure there is a way to handle this. Comment out the last part in your SQL based on the Parameter value. Where <condition> #Paramcommstrt# AND ToDate = to_date('#ToDate#',<formatstring>) #paramcommend# and in your sequencer uservariable activity check the value of the date. If it is null then set #Pa...

Thanks a lot. http://img240.echo.cx/img240/7100/crc7ih.jpg Please click on the link above for my job design. It works this way.. I'll assume file has col1, col2 and col1 is the key column. 1. I'll feed Afterset through a TRX and add a column to the existing columns and the value of the column is &qu...

I am trying to show my job design to handle the change capture. How can I paste/attach my job design in the forum/message.

Hey..how do i copy paste my job design..any help please...[/code][/url]

We have a scenario wherein we have to capture the change record information. This may or may not help you much..but this is how we are doing it. Every week we get a source file which has old as well as changed record information. We compare old file with new file and identify what are inserts, updat...

Hi Nivas, I have tried the same in one of my jobs. If the execution mode is parallel the job will always fail when run on two or more nodes. The workaround is to make it sequential and run the job. I have to agree that the job will be slow. Multiload stage would become bottle-neck.But i am not sure ...

Hi, Definitely there is a difference between sort merge and round robin collection methods. Sort Merge uses your columns (one or more that you have specified) to decide the order of collecting the results. Round-Robin, as you know, just collects the records in an orderly round robin fashion. Since y...

Hi, The reason why you are facing this problem is already explained in previous posts. This might help you. 1. Change the Execution mode of Multiload stage to Sequential mode. 2. Drop all the log table, error tables and work tables that you have specified. 3. On the main table you are trying to mult...