Delete rows before doing any transformation in datastage designer? -


i want delete rows before doing processing. don't know how in datastage designer? there stage holds sql requests??

not knowing job do "processing" can 1 job has 2 stages: row_generator , database link (depending on db). configure row generator generate 1 row only. on db stage can whatever delete ou want. job deletes rows want. after that, sequence job , add job you've done delete rows , link whatever jobs want run next - don't forget configure triggers on these links. hope helps.


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -