DSXchange

Ray,

I really appreciate if you can let me know how to contact the editor of DSXCHANGE. I already contacted IBM, but still i am finding other sources.

Thanks,
Bram

Hello,

Does any body know, who can provide Datastage training in Southern California?

Appreciate your help,

Bram

hello,

Is there a SP stage in server edition of DS? Per my understanding to call SP we have to use ODBC stage and call the SP. Please advise,

Thanks,
Bram

HI ,

I am extracting the data from csv file, which has two date columns. Date is in format MM/DD/YYYY HH:MI:S (07/01/2204 00:00:00). I want to load that data into Oracle table, i dont mind whatever the date format in oracle.

Please advise me how to do that,

Thanks,
Ram

Thanks chulette,

I got the answer. Thanks for your prompt reply.

Thanks again,
Ram

Hi,

I am trying to load the records from Excel file(.csv) into oracle table. But this file has duplicates in it. I am using Aggregator stage to remove those duplicates and loading into oracle table. When i clik on view data in oracle oci stage its saying DATA SOURCE IS EMPTY.

Please advise me,

I am sorry Ray, I really don't know about that.

Thanks,
Ram

Hi, I am trying to load the records from Excel file(.csv) into oracle table. But this file has duplicates in it. I am using Aggregator stage to remove those duplicates and loading into oracle table. When i clik on view data in oracle oci stage its saying DATA SOURCE IS EMPTY. Please advise me, Ram

Hi Chulett,

Can you please more elaborate on it?

Thanks,
Ram

Hi Sainath,

I am tring to remove duplicates, using Sort -u option, but its not any idea how to do that at unix level?

Thanks,
Ram

Hi , I got a excel file , which has duplicates. My target file is also an excel file, with no duplicates in it. How can i do that, Basicall y iam trying to remove duplicates from source(excel file) and loaded into target(excel file) Also when i click on target Sequential_File_8, view data, its givin...

mm-dd-yyyy is fine?? Also iam want to schedule it using Cron

Thanks
Bram

Hi Sainath,

Could you please more elaborate? That is also iam looking at.

Thanks
Bram

Hello every one,

Does anybody tell me how to write a shell script, it should run a sql in oracle, rename the file like , file name and on which date the script ran (file name+mm/dd/yyyy) and do ftp on to the ftp server.

Thanks in advance,
Bram

Hi every one,

Does any body tell me how to get the oracle table from my schema into the Oracle oci stage, i am not able to see any tables from my schema.

Thanks,
Bram