Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

can any one explain me about junk dimension

4 Answers  


how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  


What is difference between a gateway node and worker node?

0 Answers  


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,


why union transformation is active transformation?

6 Answers   IndiGo, TCS,






how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,


what is shared Cache. when we will use shared Cache?

4 Answers  


How to call shell scripts from informatica?

0 Answers  


What are the features of complex mapping?

0 Answers  


Parameter and variable differences

0 Answers  


Enlist the advantages of informatica.

0 Answers  


Can we override a native sql query within informatica?

0 Answers  






Categories