Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / srinivas.medagum

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

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

What is up date strategy and what are the options for update strategy?

2 Answers  

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

What is workflow manager?

0 Answers  

How to recover the standalone session?

2 Answers  

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

For more Informatica Interview Questions Click Here
Categories