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
- 11262 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What does cheating measurement mean?
Why union transformation is an active transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Enlist the advantages of informatica.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is domain in terms of informatica?
How to delete duplicate row using informatica?
what is $$$$?
wat are deployement groups in informatica, how it will be used for developers
update strategy transformation in informatica
Explain the types of transformations?
What is the difference between Active and Passive transformation?
Why update strategy and union transformations are active? Explain with examples.
Explain the shared cache and re-cache?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
