Answer / venky

write post sql in target table as truncate table tablename

Answer / honey

SQ---> Properties tab-->Post SQL
delete from target_tablename

SQL statments(s) executed using the source database
connection, after a pipeline is run

Answer / davankumar p

we have the property in session truncate option.

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

---

difference between informatica 8.1.1 and 8.6

0 Answers   TCS,

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

What is mapplet in informatica?

0 Answers  

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

What are batches?

0 Answers  

---

What is the Hierarchy of DWH?

1 Answers  

---