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
11445 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

More Informatica Interview Questions

Have you worked with/created Parameter file

0 Answers

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers

Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata

1 Answers Cognizant,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers BRAD, TCS,

What is an Integration service in Informatica?

0 Answers

how can we load starting with 11th record of a table from source to target

6 Answers IBM,

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers

Explain the types of lookup transformation?

0 Answers

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?