hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
- 4 Answers
- 10737 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
Describe an informatica powercenter?
What do you understand by SOA of Informatica?
how many types of dimensions are available in informatica?
What is informatica?
How can we use mapping variables in informatica? Where do we use them?
What are mapplets? How is it different from a Reusable Transformation?
What is substr in informatica?
How to implement security measures using repository manager?
How union transformation is used?
What are connected or unconnected transformations?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the mapping parameters and mapping variables?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
waht type of interface is used for testing the data in informatica
What do you mean incremental aggregation?
