How to delete the data in the target table after loaded.
Answer Posted / venky
write post sql in target table as truncate table tablename
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
explain abt ur project architecture?
What differs when we choose the sorted input for aggregator transformation?
explan ur project architecture?
How would you join a node to the already existing domain?
Explain direct and indirect flat file loading (source file type) - informatica
What is informatica? Why do we need it?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Name the different lookup cache(s)?
What is meant by target load plan?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to go to the older version for a mapping?
How to use procedural logic inside infromatica?
Explain dynamic target flat file name generation in informatica
What is an aggregator transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?