Answer / suresh

2008

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

What is data transformation manager process?

0 Answers  

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

---

What is a command that used to run a batch?

2 Answers  

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

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

1 Answers   Accenture, Unisoft Infotech,

---

What is dimensional table? Explain the different dimensions.

0 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---