in target table u can write pre-sql statement as truncate table tablename

Hi Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.

Thanks
Abhishek

Question Posted / venky

5 Answers
18066 Views
CSC, I also Faced
E-Mail Answers

Answer Posted / venky

in target table u can write pre-sql statement as truncate
table tablename

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rank transformation?

992

Explain your project of banking domian.

1654

What is the meaning of up gradation of repository?

1994

Is it possible to revert a global repository to local one and why?

1086

What is a connected transformation?

1127

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2363

Under what condition selecting sorted input in aggregator may fail the session?

1128

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

1163

How we can create indexes after completing the loan process?

1215

generate date / time dimension in informatica

1130

what is the Default Source Option For Update Strategy Transformation?

1246

How can we use mapping variables in informatica?

1067

Name the different lookup cache(s)?

1238

What is aggregator transformation in informatica?

955

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1917