DSXchange

Do the null handling and use the isvalid function

I will update once i get the answer from my DBA .

Thanks alot craig .For sure i will contact my DBA regarding this . I have posted because most of my doubts related to oracle got resolved here .

Sreeni ,

I have mentioned the same while posting the question . I have still raised in this forum because its indirectly related to datastage & i know that many of the members are versatile in multiple technologies ( which is a trait of a good ETL designer & developer )

Thanks alot craig for your quick reponse . "A data save in a direct path load is analogous to a commit in a conventional path load" According to the above statement , If i mention DIRECT=TRUE , ROWS=1000 how it will it work internally . I want to know will ROWS option will have any effect ...

Hi Everyone , I know that APT_ORAUPSERT_COMMIT_ROW_INTERVAL parameter for DIRECT=TRUE wont have any effect . Is there any way we can control the number of rows commited DIRECT=TRUE option ? While browsing through net , I got the below information . " ROWS = rows_in_bind_array The precise meanin...

you cannot do compilation from command prompt in server .dscc is the utility available in client side .

Hi Kim ,

I think they have mentioned "load" as an option . I believe there is no reject for it .

I hope you are using oracle load method . can you try with upsert oprion if possible and let us knw the result ?

Import COPY BOOK definition and read the data . Also , dont forget to handle packed decimal fields if there are any ...

Thanks

I think you can use before job routine to execute the same ....

Speak to DBA ....

Craig ,

Thanks for correcting me .I have not worked in server jobs .How server job transformer is different from BASIC transformer ???

Thanks
Nagarjuna

search for DSXCUTTER and DSXCONCATENATE ....you can find the perl script posted by one of our dsxchange member ...

There will be folders ..within that search for stages ...parallel , server .Within server , you can find basic transformer