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
- 11430 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
whats the logic to load the lower level of granularity of data to fact table.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is workflow? What are the components of the workflow manager?
In informatica workflow manager, how many repositories can be created?
Which transformation is needed while using the Cobol sources as source definitions?
Reusable transformation and shortcut differences
What are data-driven sessions?
State the differences between sql override and lookup override?
Explain the types of transformations?
What is the surrogate key?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the difference between a data warehouse and a data mart?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Is it possible to use a client with different version than that of its Informatica server?
In how many ways we can create ports?
