Interested to Buy Any Domain ? << Click Here >> for more details...
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
- 4 Answers
- 11412 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
write sql query in tgt property .. per sql & post sql
| Is This Answer Correct ? | 5 Yes | 1 No |
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 |
Answer / suresh
we can do through update staytgy tr we can delete the row's
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / shyam
by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
how to work with mapplet designer in informatica?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
How union transformation is used?
can we see default group,when we use router?if yes how?
Which transformation is needed while using the Cobol sources as source definitions?
What is xml source qualifier transformation in informatica?
Define the various join types of joiner transformation?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
what is the size of u r project? and what is the size of source file?
what is mean by flag 4 in update strategy t/r
Teradata 
