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

Answer Posted / suresh

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

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the advantage of informatica?

624


Explain sessions. Explain how batches are used to combine executions?

571


what is INFORMATICA TESTING process

1814


How can you validate all mappings in the repository simultaneously?

734


How to update source definition?

607






in reporting we add some new objects,how we get the count of the newly added objects to the report

1729


can anyone explain me about retail domain project in informatica?

7386


Separate from an archive server and a powerhouse?

468


What do you mean by worklet?

602


What is a predefined event?

632


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1594


What are the features of complex mapping?

616


Can we override a native sql query within informatica?

607


What is meant by active and passive transformation?

560


Enlist the various types of transformations.

531