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

What are the performance considerations when working with aggregator transformation?

674


What do mean by local and global repository?

701


Why update strategy and union transformations are active? Explain with examples.

708


How to generate sequence numbers using expression transformation?

637


Informatica settings are available in which file?

589






What do you understand by a term domain?

668


what is the size of your data warehousing?

1669


Can informatica load heterogeneous targets from heterogeneous sources?

695


What do you mean by blocking transformation?

579


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1525


What are session parameters ? How do you set them?

1375


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

826


Briefly explain the aggregator transformation?

591


What is domain and gateway node?

692


How to go to the older version for a mapping?

600