Answer / abhinaw prakash

You cannot rollback the data in case of failed session.
In this scenario you need to write delete query(delete from
tablename) and uncheck the Truncate target table option.

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

What are the different ways to implement parallel processing in informatica?

0 Answers  

---

what is threshold error in informatica?

1 Answers   TCS, Wipro,

---

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

---

what is SDLC way of code development?

0 Answers  

---

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,

---

What is Session and Batches?

0 Answers   Informatica,

---

When will you use SQL override in a lookup transformation?

1 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---