DSXchange

I monitored the Job through the Director and the Scheduling tool. There were absolutely no warnings. When i said monitor, I asked you to see the no. of records extracted from source and loaded to target. Right click the job in Director and select monitor. Then you can see the details. If there is a...

You don't get any warnings...? So have you monitored the job and looked how many records are coming from source and loaded to target? End Users? Do they see the data through Cognos or BO or any other OLAP tool? Are they using pre-canned reports or adhoc queries against the DW table? If you give us ...

Hi All, Myproject has a job that is loading data into an AS400 table. This is an existing job and there were problems eisting due to bugs in previous jobs. But the record counts always used to match. We fixed the bugs in the preceding jobs and lo behold!!! i load 907 records as per DataStage (not a ...

I asked IBM and they said DataStage cannot load data into nested tables. If we need this functionality, we need to upgrade to 8.1. So that settles the matter. They did not seem open to any work around or patches. I am going with the SQL Loader and i have gathered some support from the DBAs. We shoul...

DataStage server does not have enough space for Staging tables for sql loader. Plus one of the old timers read somewhere that Oracle may do away with SQL Loader and he wont sign off on my project for that reason. I am normalizing the data on datastage server and have changed the minimum modulus and ...

Thats the funny part. My Source Database is UniVerse. I am trying to put the denormalized data into Oracle Nested Tables to resolve the normalization problem. If i do the normalization, i am blowing up 28 million records to 133 million records in Oracle. The Load time is 24 hours and i need options.

I need to load data into a nested table in Oracle. The columns are: Key A B C D The key column is the only normal column. A,B,C,D are all objects and are part of the nested table. I contacted IBM and they said DataStage 7.5.2 cannot do this. Object Based Database concepts are atleast 10yrs old. So t...