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
496 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
update a record in target table without using Update strategy using Informatica

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

0 votes
Truncate target Table based on rows in a Target Flatfile

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
Informatica: If session fails after loading 10000 records in the target, how can we load 10001 the record when run next?

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?

...