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

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

Question Posted / shyam

Answer Posted / shyam

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

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain why we use partitioning the session in informatica?

1021

Write the unconnected lookup syntax and how to return more than one column.

1065

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2199

What is sorter transformation?

991

What is workflow? What are the components of workflow manager?

1133

What are the new features of informatica 9.x developer?

912

Enlist few areas or real-time situations where informatica is required.

1033

How to delete duplicate row using informatica?

992

How can informatica be used for an organization?

1141

What is meant by query override?

1013

What are the limitations of joiner transformation?

1055

What is a repository manager?

1039

What are the various types of transformation?

1109

How many input parameters can exist in an unconnected lookup?

1506

What is rank transformation in informatica

1120