hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?

Question Posted / srinivas.medagum

4 Answers
10058 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / pooja

write sql query in tgt property .. per sql & post sql

Is This Answer Correct ?

5 Yes

1 No

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / ankit kansal

The Problem asked about deleting rows using SQL T/R...

So write a sql query like
Delete from table name where col_name = ?input_port?

This is how u will be able to delete a particular row using SQL trans..

http://deepinopensource.blogspot.in/

Is This Answer Correct ?

2 Yes

0 No

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / suresh

we can do through update staytgy tr we can delete the row's

Is This Answer Correct ?

3 Yes

2 No

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / shyam

by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.

Is This Answer Correct ?

3 Yes

2 No

Post New Answer