DSXchange

If the local message handler is viewable in the message handler manager, then the logs can be suppressed, if this is what you are looking for.

This a reverse scenario to what you want. Did a search on the forum.
Here is the LINK.
Kenniths saying is similar to the link.

Mirja: You wasted your last post unfortunately, doing the same as you said. tostay: You can how two output links, each for insert and the other for update. This will be after doing the delta on the dataset. So while inserting or updating you can pass the required field and have it pass as a string. ...

This seems to be an installation issue definetly or try to restart the box before going back to installation.
If that gives no cigar, go back to the installation of your plug-ins.

What do you exactly want to do. I have come across unpivoting horizontal rows ( horizontal pivot). And have handled them without using the vector stage. Post what you require to do?

If you are rarely truncating tables, another thing would be just to load the table with /dev/null . This how i have done quite many times in DB2.

You are trying to do a Left outter join. The values that match the Lookuptable will only be outputted or if you pass the link from the source to the target also, then the matched and non-matching columns both would be in the result.

When i initially gave my idea of passing a parameter in the before tab of the sql, i actually tested that with the DRS stage. I couldnt test it with the OCI because we dont have Oracle here at our client place. In the DRS stage, even if you pass nothing, it would work, without any warnings. I have n...

I did take care of those.
But I replaced a direct OCI lookup with a Hash, it is giving me the desired results.
So my curiousity still lies, that why was the OCI lookup not availing the purpose.

1.You can use a transformer to unpivot the source.
2. We have lookup files sets and Data sets. These can be used for lookups.

I am looking up a table with Pk's generated through Oracle NextVal seq ( not done through DS ETL). For some reason the driving data with unique column is not joining with the lkp table also having that unique data.
SRC:
UniqKey
A
B
C

LKP:
PK UniqKey
1 A
2 B
3 C

Kris,
I just made a test job and tested the solution i proposed. It works just fine.
cheers

:oops: i totally overlooked that. Thats what happens when you try to multitask. So coming back to the problem, in the OCI stage, go to the tab sql, and in there is a tab before. in the section specified there put ur delete command. Test it. If it works, parametrize the Delete command and put the par...

For loading the table, what stage are u using, and what DB is it?

If you are using a DRS stage, then in the before tab you can specify a parameter, and whenever you want you can pass a delete command in there or if your id has truncate authority, you can pass a truncate command in there. That might do the trick
cheers