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
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the difference between informatica 7.0 and 8.0?
Can anyone tell me the new features in Informatica 9 Version?
What is olap (on-line analytical processing?
update strategy transformation in informatica
How do you update the records with or without using update strategy?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is confirmed fact in dataware housing?
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
r u done any partitions in ur project?
What are the types of schemas we have in data warehouse and what are the difference between them?
whats the logic to load the lower level of granularity of data to fact table.
Under what condition selecting sorted input in aggregator may fail the session?
What is workflow monitor?