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

In joiner, how to load Master table in Target?

2 Answers

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers Amdocs, Deloitte,

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers IBM,

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers iGate,

Define mapping and session?

0 Answers Informatica,

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers Span Systems,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers Infotech,

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers DELL,

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers Accenture,

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers IBM,

what are the deliverables?in your project?

0 Answers DELL,

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers KPIT,

For more Informatica Interview Questions Click Here