top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can we delete a record or truncate in target table using SQL T/R?

0 votes
475 views
How can we delete a record or truncate in target table using SQL T/R?
posted May 11, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

By using dd_delete(2) in UPDATESTRATAGY transformation we can delete rows.

answer May 12, 2015 by Shweta Singh
Similar Questions
+2 votes

How can we update a record in target table without using Update strategy?

0 votes

I have a workflow which loads data from a Flat file to a Stage Table after a few basic checks on a few columns. In the mapping, each time my check fails (meaning if the column has an invalid value) , I make an entry to a ErrorFlatFile with an error text.

Now , I have two targets in my mapping. One being the Stage table and the other is the Error Flat File.

What i want to achieve is this ? Even if there is one entry in the ErrorFlatFile (indicating there is an error in the source file ) , I want to truncate the Target Stage Table.

Can someone Please help me with how i can do this at the session level.

+1 vote

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

...