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.

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

What is meant by query override?

0 Answers  

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

What is the difference between a table and the materialized view?

2 Answers  

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---