Answer / krishnakanth

If the informatia user id does not have permissions to
truncate the table in the database. Then there is no other
way we can truncate the table.

Anyways try with this option. Try to write a pre-sql
statement in the session. So that first the sql statement
will execute and then the session will start executing

Answer / sunil

Abhishek Bhai,

Possible Solution:-

1. While creating connection, use such a generic id, which
have all the permission on DB objects. This way you
definitely can play with your Target object.

2. If no such credential available then, Delete and commit
process can be implemented in pre-sql.. but process will
become very slow (depends on volume of data).

Cheers !

Answer / raj

Use delete * .... in pre-sql

Answer / venky

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

Answer / ravi

in the warehouse designer,in targets ,in generate and
execute option truncate the table

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

How to load duplicate records in to a target table which has a primary key?

2 Answers  

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

Why union transformation is an active transformation?

0 Answers   Informatica,

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,