DSXchange

I am sorry.. I thought you have created just one dummyColumn like "a" ..

Col1 through Col5 are also keys. I was forced to create a Dummy column because I could not include Col1 in the Group and also for 'Column For Calculation'. I was getting the error: "It is not legal to set a reducer (Col1) to be the same as a key field" Now, my problem is, the aggregator i...

chulett wrote:If you really want to know which way is more performant in your environment with your data - try both! Let us know.

I sure will .. I will try with about 3M rows and see how it behaves!!

Thanks Ray.

ray.wurlod wrote: If you want "now" for each row, simply use this expression as the stage variable derivation for each row processed.

thats how, I wanted to implement option #2.

I am in dilemma which one to chose Transformer vs Oracle_default value/insert statement

Yes chulett!!

Any other methods other than these two options (#1 and #2)?? And is it better to go with #1 compared to #2??

Thanks DsGuru.

You mean to say, during table creation have that column defaulted to currentTime (of row insertion) and pass nothing for that column in Insert SQL?? That looks like a better option than my #1.. thank you!!

Hi, I was wondering if there is any better method for doing this. For each row to be inserted/updated into the database (oracle) I need to include current time stamp information in the row in a separate column. I was thinking of following tow options: 1) Oracle Enterprise stage, Have a user defined ...

The first message is a warning that there is a difference between the character map set for DataStage NLS and that set by the environment variable NLS_LANG (which may not be set at all). This may affect handling of non-Latin characters, whether in View Data or in processing Hi ray .. Can you please...

I find it odd that the encrypt has 4 parameters (unabalanced in your post) and the decrypt only 1. Is that correct? Sorry, missed copying full query. I have used the correct/balenced query: SELECT xxxx, (RPAD (xxxx, LENGTH (xxxx) + 8 - MOD (LENGTH (xxxx), 8), ' ')) FROM tablet As entioned briefly e...

kumar_s wrote:Hi Prasad,
Not necessary to post twice, Pls delete the other post.

Hi Kumar,
Sure. Next time, i will try not to post twice.

Thanks,

did u check the metadata on boths sides? like key clomuns.
BTW, what is the datatype for key column??

Sorry for bringing the old topic up .. I am wondering if there is anything else that we need to change on datastage side other than a) Check OS level authentication box b) Enter DB name, leave ID/pswd fields c) get the DBAs to setup ops$userID on the unix server and REMOTE_OS_AUTHEN = true thanks in...

Here is an idea

After Job 1 insert a script and return a value to indicate continue/stop.

Use the script to check the value you are looking for!!

when we have similar problems.. changing varchar filed lengths to be the same in both primary and reference inputs ..solved the issue.

Columns getting dropped issue.. Runtime column propagation might be the culprit. Uncheck RCP on atleast one of the inputs and compile. OR try renaming one set of columns .. say add "_sec" to each column name A. Define them in output columns grid B. Use KEY option on properties tab of the s...