hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
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 is incremental aggregation?
Explain what is informatica metadata and where is it stored?
How can we improve session performance in aggregator transformation?
Repository user profiles
where to store informatica rejected data? How to extract the informatica rejected data?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is rank transformation in informatica
What is a standalone command task?
what are the Methods For Creating Reusable Transformations?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What could be the possible resons of locks by user?
Explain the code page compatibility?
What are the measure objects?
Enlist the differences between database and data warehouse.
Explain the types of lookup transformation?