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


Please Help Members By Posting Answers For Below Questions

explain abt ur project architecture?

1917


What differs when we choose the sorted input for aggregator transformation?

788


explan ur project architecture?

1822


How would you join a node to the already existing domain?

900


Explain direct and indirect flat file loading (source file type) - informatica

1072


What is informatica? Why do we need it?

842


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1924


Name the different lookup cache(s)?

924


What is meant by target load plan?

733


Name at least 5 different types of transformations used in mapping design and state the use of each.?

889


How to go to the older version for a mapping?

799


How to use procedural logic inside infromatica?

845


Explain dynamic target flat file name generation in informatica

838


What is an aggregator transformation?

819


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6865