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
- 11471 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 |
in static and dynamic which one is better
Explain constraint based loading in informatica
Enlist the advantages of informatica.
How can yoU improve session performance in aggregator transformation?
How are the sources and targets definitions imported in informatica designer?
what is procedure to use mapping variable in source qualifier transformation? with example
What is depict expression change?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
without using rank transformation how can we rank items by using some other transformations
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the prerequisite tasks to achieve the session partition?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Teradata 
