Answer / sunil

)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area

Explain lookup transformation in informatica

0 Answers   Informatica,

---

how to load duplicate row in a target

4 Answers  

---

waht is dataware house

2 Answers  

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

---

what transformations are used for Variable port?

2 Answers  

---

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---

Why we use partitioning the session in informatica?

2 Answers  

---