DSXchange

Hi,

I forgot mention. We did not used NLS setting. NLS is disabled.

Thanks
Parag K

Hi,

I forgot mention. We did not used NLS setting. NLS is disabled.

Thanks
Parag K

ray.wurlod wrote:But easier to change databases subsequently when some smooth-talking sales person convinces management that dBase IV is the only database you'll ever need and it's cheap as well.

Update - We have been notified by IBM that there is patch available for this issue.

Thanks

Could be time to mark thread as resolved, then. We tried to insert data with other stages like Ora OCI and DRDBMS by keeping same width 11,2 and display 13 data is getting inserted properly. but our issue is, when we keep same width and scale (11,2 and display 13) in ODBC Stage. Its NOT working and...

DeepakCorning wrote:Did you try increasing the scale and test it?

Yes, We increased width to 13,2 display 15. Data got inserted properly.

Thanks

Hi,

I am wondering. Can I user DataStage Stylesheet in MetaStage ?

Since I am not much familiar with Stylesheet. Does any one have good Stylesheet ? and like to share ...

Thanks
Parag K.

Hi Tom, Thanks that helps .. One more think, how about Business domain, Glossaries ...etc ? Should I have to recreate them too ? If answer is yes .. then I will need your suggessions on one more thought .. Create only one repository then 1. Create/Update ERWin model. 2. Import ERWin model into DataS...

Hi All, Thank you all for giving suggestions. I partially agree with you guys. I will try to take different job for benchmarking.. Still I feel If your Database, Network and Hardware is tune and strong and Compare to other ETL tools. DS should do better job than this, But this is not a forum for dis...

Right now our jobs are in oracle and Unix .. U can say we are doing kind of benchmarking before starting full development... Time is very critical because its fin org. Some jobs are daily and some monthly. Its huge TB database and everyday we are loading millions and millions records.. Do I have to ...

Andrw, If without tranformation I am writing to a file its takes 15 sec. I tried to split Insert and update. It takes same time 45 to 50 sec. Its Oracle Stage and Update Query is Tune. Srini, Array size is 1000 and In mapping only three transformations are present. I cant insert more than 1 IPC. I h...

Hi, I created a job. which is very simple. 1. Read EBCDIC file --> Transform --> Insert/Update Table. We are loading around - 16300 Records. Right now it is taking around 50 Sec. 2. After this I did this Read EBCDIC file --> Transform --> IPC --> Insert/Update Table. This takes around - 40 Sec. 3. R...