Answer / santhosh

sql override is used to write sql select statements
sql override contains in source qualifier transformation

we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

how you will maintain version?

3 Answers   CTS, TCS,

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

---

---

what is data driven?

5 Answers   TCS, Wipro,

---

Differnce between filter and router?

14 Answers   IBM,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

Can you create a flatfile target

3 Answers   ABC,

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---