DSXchange

Script based, using cut, grep, and wc can accomplish what you need. Using DataStage you could just check the columns as you process and write out rows that qualify for loading, and that don't send to an exceptions file. You could check the exceptions file when finished and based on finding rows ele...

Hi,

I have a source file with 20 cols.

functionality needs to be is ...

1) check for a particular value say "ABC" in 1st 15 cols. If I find any such entry, then should not load that file.

how can we do this in DS?

thanks

Hi I have a problem with the date stored in Shared container. I have already posted in this forum sometime back; as i did not get the required outcome, i am posting again. We are working on Peoplesoft 8.9upgrade project. The lastupdateddate will be stored in the shared container. If we open and see...

thanks for quick reply,kcbland. I am loading that particular col of that row into a HASH and doing look up to bring that value into the target..its working this value is different for different source files...thanks again Iam throwing out the row which contains the DATE, as that is header data Don't...

Thanks a lot your time and effort. Actually,Iam throwing out the row which contains the DATE, as that is header data. and , as this is a fixed width file, I have some IDs in the same colunm that of DATE, where rownum > 10 ( which I need to bring over to DB). Is there a way, to Pick the (COL2) WHERE ...

Iam trying to pull the data from a report file into Table (Oracle-9).I have header and trialer in the report file. I managed to filter header & trailer rows(based on @inrownum) from the report file and pull the data rows that I needed into Oracle table. I have a requirement to grab the DATE from...