| Data Volume Problem [message #387505] |
Thu, 19 February 2009 10:43  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Hi All
I have a major problem with the amount of data i'm loading into the OWB. I have four tables
STG_GEM_EVENTS_ITS,STG_INCSENLUT,STG_ITS_SENSOR15 and STG_RESPONDINGUNITS_ITS.
The problem is the table STG_ITS_SENSOR15 has 3 millin records and the STG_GEM_EVENTS_ITS has 116 records.STG_GEM_EVENTS_ITS and STG_INCSENLU have a common field, so i did a lookup based on that common field "RTDIRNTYMEAS" (so i have to get 116 records) and in the output i get the "ASSET_ID" field which is a unique filed in between the tables "STG_INCSENLUT" and "STG_ITS_SENSOR15" and now based on this common field i did a look up on the table "STG_ITS_SENSOR15" (accordingly i should get 116 records), but for some reason i'm getting 12 million records.Am i doing some thing wrong here?
Please any help is greatly appreciated and needed.
Thanks
|
|
|
|
| Re: Data Volume Problem [message #389596 is a reply to message #387505] |
Mon, 02 March 2009 20:02  |
ajitpal.s
Messages: 204
Registered: November 2006
|
Senior Member |
|
|
|
I think this is due to your sql logic defined in mapping and not the data volume problem, can you take a look at the PL/SQL Package generated by your mapping and check the SQL to see if it meets your needs.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
