whatever data u want to delete from target table,simply go with truncate

How to delete the (flat file) data in the target table after
loaded.

Question Posted / james

Answer Posted / james

whatever data u want to delete from target table,simply go
with truncate option.

Is This Answer Correct ?

1 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What is meant by query override?

1013

What is workflow monitor?

1007

Explain target update override in informatica

1057

How to convert multiple rows to single row (multiple columns) in informatica

1331

Suppose we do not group by on any ports of the aggregator what will be the output?

997

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1001

How would you copy the content of one repository to another repository?

971

What does refresh system mean, and what are its distinctive choice?

1098

What is domain in terms of informatica?

965

What are the mapping parameters and mapping variables?

1108

What is the use of target designer?

996

What does reusable transformation mean?

1083

Why filter transformation is an active one?

941

Describe an informatica powercenter?

1050

4 yrs etl devloper roles and responsibilities?any body give solutions

2094