Answer Posted / reddy

Create two target instances,and connect sq to two instances.
Then we will get desired output...

What is the session task and command task?

1052

---

Which files are created during the session rums by informatics server?

1176

---

Can we override a native sql query within informatica?

1034

---

How can you differentiate between powercenter and power map?

1085

---

What are the main features of Oracle 8i with context to datawarehouse?

2109

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2123

---

Where can we find the throughput option in informatica?

1057

---

What are session parameters ? How do you set them?

1843

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2098

---

What is sorter transformation?

1041

---

What are the designer tools for creating transformations?

1112

---

What is blocking transformation?

1139

---

Explain the informatica workflow?

1050

---

difference between informatica 8.1.1 and 8.6

3675

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---