hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
Answer Posted / shyam
by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Difference between Target-based loading and constraint-based loading?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is a filter transformation?
What are the components of the workflow manager?
what is index?how it can work in informatica
What do you mean by worklet?
What is the function of union transformation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is session task and command task?
Why do you use Mapping Parameter and mapping variable?
What does “tail –f” command do and what is its use as an Informatica admin.
4 yrs etl devloper roles and responsibilities?any body give solutions
What is an aggregator transformation?