DSXchange

Yep. Only add ETL_DATE, others are not change.

Anyone help me, plz!

Sorry about my careless. The simple job is https://lh5.googleusercontent.com/-hyW9x6lv_vU/ThVwb4aEbfI/AAAAAAAABhg/cnSbmq--5yI/Job_Simple.JPG At the transformer stage: https://lh3.googleusercontent.com/-r5vVZlp_CKg/ThVzX_ZWTlI/AAAAAAAABhw/kieh6eRxofo/s640/Add_ETL_DATE_Simple.JPG But the Sequence File...

I have already created the job like this: https://lh4.googleusercontent.com/-J9sTRCywumI/ThVZ4kzwbaI/AAAAAAAABg0/jjycT9tZDQs/Job.JPG . Detail in these Stage are: + Enable RCP in Source stage https://lh4.googleusercontent.com/-dhGUQkFeSy0/ThVZ6R-dShI/AAAAAAAABg8/I8jPdbbVr-0/s576/SourceDB.JPG + Add ET...

Thanks for your response. Tables in source (DB2) and target (Oracle) are identical. Maybe, I need to add the current date to these tables. I know a little about RCP (Runtime Column Propagation) and I also try this sample http://www.isecor.com/drupal6/node/163 . But it's wrong. How can I define mappi...

Hi all,

I'm working in InfoSphere DataStage 8.0.1 (Windows OS) and facing the requirement to transfer all tables (in a schema) from DB2 into an Oracle database. The DB2 database has about 3000 tables.

Anyone have any idea?

Thanks so much.