среда, 13 апреля 2016 г.

DataStage create job that truncate table. Delete Data from table using DataStage job

Now I am working as ETL tester. Our main tool is IBM Datastage, so I will leave small tips to me for future development.

Here I provide steps.
1. Create parallel job 
2. Use Row Generator that generates 1 row for one column  


3. database connector(Oracle in my case)
4. Ctr+ J add parameter Table name


Save and compile job ) 
Have a nice day


Комментариев нет:

Отправить комментарий