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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
If informatica has its scheduler why using third party scheduler?
How to differentiate between the active and passive transformations?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Enlist the differences between database and data warehouse.
What are some examples of informatica etl programs?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the difference between a repository server and a powerhouse?
Plz can any one say me how to get the informatica certification materials and dumps
explain abt ur project architecture?
What do you mean by channel change?
What are ETL Tools?
What is decode in informatica?
Define update strategy?