Answer Posted / sri ram

You can do unit testing by testing your mapping
1.develop the mapping,take target as a .csv file(if the
target db location is remote)
2.give some input satisfying business rules
3. check whether the output is generated appropriately

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1494

---

While migrating the data from one environment to another environment how would you manage the connections?

1090

---

How to go to the older version for a mapping?

1098

---

What is the format of informatica objects in a repository?

1019

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2339

---

How to delete duplicate row using informatica?

1046

---

What are the types of caches in lookup?

1048

---

How can we delete duplicate rows from flat files?

1223

---

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?

2026

---

Write the unconnected lookup syntax?

1084

---

Describe the impact of several join conditions and join order in a joiner transformation?

1062

---

whats the logic to load the lower level of granularity of data to fact table.

2276

---

Which transformation is needed while using the Cobol sources as source definitions?

1174

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

---