Answer / praveen kumar

we can, but we have to copy the mapping first and then we
have to copy the session....

Answer / kalyan

Folder :Yes
Repository: No.

if you want to move the session to another repo, then you
have to export the session and then import it in the target
Repo.
This assuming that the mapping has alraedy been moved..

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

---

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

WHAT IS FACT TABLES?

2 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

What is a sequence generator transformation?

0 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

why we use informatica in our project?

2 Answers   TCS,

---

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?

0 Answers   TCS,

---

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

0 Answers  

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---