Online Tutorials & Training Materials | STechies.com
Register Login

How to Delete the Table Contents in Pre Session SQL?

|| || 2

How to Delete the Table Contents in Pre Session SQL?
Stechies

Hello Experts,

I have a requirement where i have to delete the table contents present in another schema in pre sql session command on session run.

How we can do that apart from creating a dummy mapping?

P.S.

i) Can't change the parameter file.
ii) Can't give the different schema user to access the table.

Thanks in advance !!


Comments

  • 16 Oct 2015 1:07 pm

    you need to create DB link to access and later user should have delete privilege for your scenario.

  • 16 Oct 2015 1:08 pm

    Simply create a stored proc transformation in mapping set to pre target load and configure other schematics connection to it.

    Write stored procedures. For deleting the data.

Related Articles