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
- 11288 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 are the types of caches in lookup?
Slowly changing dimensions, types and where will you use them
how many types of dimensions are available in informatica?
Enlist the tasks for which source qualifier transformation is used.
what is SDLC way of code development?
What is the difference between stop and abort in informatica
Is there any target staging area in informatica not staging area
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
list out all the transformations which use cache?
How can we use batches?
Under what condition selecting sorted input in aggregator may fail the session?
Which files are created during the session rums by informatics server?
What is aggregate cache in aggregator transformation?
What is mapplet in informatica?
