DSXchange

Since you have enclosed with in double quotes and assuming you have done this setting in your Seq file as well (i.e. anything enclosed with in double quotes as a one column value).

Now you can read the first column as a varchar and remove any comma's and load the data into the oracle object.

thanks!

Please touch base with your system admin.

Thank you all, I gone through the manual and i searched in DSX for the FTP plugin details, I tried to work through it, Now i have some queries, Can i connect to the local machine i.e.,Localhost,? If so, What is the properties that has to be set as mandatory? I am having a 3GB file in my desktop of ...

if you are dealing with huge amount of data then use Merge Stage to capture the unmatching records.

Thanks,
Waseem.

fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname

dont give any spaces in between and then try, it is working for me.

fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname

dont give any spaces in between and then try, it is working for me.

Hello,

if your triggering your job through UNIX script then easily you can do this task with in shell script.

Ex:
echo " filename date +ymdhms">file.dat # before triggering job

wc -l<file.dat >>file.dat # once job is done.

Thanks,
Waseem

Hello, My understanding says u want to provide a input value and get the output records it means you want to send record to SP stage and get the records from SP stage, if so then make the procedure type (comes under syntax tab) as Transform so that u make it to send and receive the records. Thanks, ...

Hi,

You can use Stored Procedure stage, Use SP stage as transform stage so that you can provide Input values and get output values.

thanks,
Waseem

Hi Deepti, u can do it through Shell script, I had the similar situation. login into ur remote server as telnet ####################Code#################### ( echo USERID; sleep 2; echo PWD; sleep 2; echo "rm FILE_PATH/filename"; sleep 2; )| telnet SERVER_NAME>log.txt OR if you want to loo...

Hi,

Table1: c1, c2, c3, c4
Table2: c1,c2,c3
Table3: c1,c2

select c1, c2, c3, c4 from Table1
select c1, c2, c3, 'T2C4' as c4 from Table2
select c1, c2, 'T3C3' as c3, 'T3C4' as c4 from Table3

After funnel you can set NULL values/any desired values in those columns using transformer.

Thanks,
Waseem

Hi,

Please can you use diffrent Trim functions of datastage.

like TrimLeadingTrainling(), just try with this option.

Thanks,
Waseem

Hi,

if you are using this operation "Div(AsFloat( DSLink3.INSTR_SET_HRS), AsFloat(10)", then it will return only the whole part of a number.

Use the below function and try.

AsFloat(AsFloat(DSLink3.INSTR_SET_HRS)/AsFloat(10.0))

Hope this work will.

Thanks,
Waseem

Hi, Map the value like this outlink.field01 ==> StageVar1 if StageVar1=StageVar2 then 'R' else 'P' StageChkVar outlink.field01 ==> StageVar2 In Transformer Constraints, u can have condition as StageChkVar='P' Other Simple Way would be have a remove duplicate stage Sort data based on first by field01...

i have developed parallel job for the replace load where one of the output Archeive filename must have prefix Date and time how to acheieve.So for every run Date and time must change and it must overwrite(For eg:<Path><date&timefilename.dat>) and frequency of load is daily. In UNIX: if you are ...