Where clause oracle.

[D19PAL]

Hi guys.

I'm loading data from an Oracle database.  I've tried to do a where clause on the select statement but it doesn't work.

Do I need to LOAD the data first and then do the where clause in a new table via resident table?

Or is there away to do it with the original load?

Thanks

[Digvijay_Singh]

It should work with the original load, something else might be causing the issue, if you need more help please share the script and error details, I am sure someone should be able to identify the problem over here.