DSXchange

Possible

Use RCP in the Input DB stage , parameterize the query and pass it at runtime(you may use parameter set)
But the good way is to create separate jobs for better maintainence.

What is the datatype in dataset while loading?

<Parameter specified but not used in flow>.Well,this may come due to various reasons.It will not give any validation errors,as this is not a syntax error.Check the flow once again.

Success!!I played it as string and followed #2 in my post.Now all the rows loading into the database.But I wonder when I put the data type field as per the target table in OE stage,why don't the DS load it?Can you justify?

Thanks for response.

[quote="priyadarshikunal"]What if you change the method from upsert to load? does it loads data correctly?

I don't have DBA privileges to do direct load.

It does, actually, with a Timestamp you have to include the time portion even if it is all zeroes. I always treat Oracle DATE fields as Timestamps in job and ensure a proper time portion. ... I implemented below conversion: StringToDate(lnkname.column,'YYYY-MM-DD'):' ':'00':':':'00':':':'00' Out of...

Yes.The source column is in the same format defined 'YYYY-MM-DD'. One more point is ,when I import Date field from Oracle DB,it reports in datastage as Timestamp.But I assume that doesn't make much difference as it is oracle.

My target is Oracle 10g database.Here is the code snippet. Dataset----->T/F------->OracleEnterpriseStage I have a varchar field from input dataset which is to be loaded as Date in Oracle target. 1)I kept StringToDate(<lnkname>,"%yyyy-%mm-%dd") in transformer---All records are rejected sile...

The mistake done by me was appending double quotes at the front and rear ends of the query in UserVar Activity.It was running successfully after I remove them.But DS puzzled me giving the Oracle:identifier too long...

Thanks for your help

select <schemaname.tablename.columnname>(30 column names) from <schemaname.tablename> where to_char(schemaname.tablename.test_date,'YYYY-MM-DD')='2010-07-25'----Query used I checked with select * from <tablename> where to_char(test_date,'YYYY-MM-DD')='2010-07-25'. Errors logging for both: Message:OR...

All the column name lengths are <30.But still DS logging "Oracle identifier too long" and "query not ended properly" errors.

What happens if you add a ";" to the end of your query? ... ------ Same error I forgot to mention another error:ORA-00972 identifier too long. After some search,I found that some clients do not accept VARCHAR>31.I am using Oracle 10g version. I have columns which had VARCHAR>31.Is this cr...

I have a parallel job where the query is parameterized(RCP ON). Oracle Enterprise------>Seq File This parallel job is connected in a job sequence wherein UserVariable activity used. A where condition is kept in the query like "where to_char(sample_date,'YYYY-MM-DD')='2010-01-25'". I am pas...

Open in a new post then.Anyways,Edit the config file with the desired number of logical nodes and make the job run with this config file.But this node enhancement depends on resource availabilty.