Answer Posted / rani

Take Source Qualifier,next place sorter t/f,select option Distinct in sorter and load it in Unique_target.

Take lookup transformation and lookup on target and compare it with source, when a record occurs more than 1 ,delete that record from target using Update strategy -DD_DELETE 2 and load
in Duplicate_target.This is a source in another pipeline and take unconnected lookup and write lookup override like count(*) having >1 then load them in Duplicate_target.

What is a grid in Informatica?

1058

---

Differentiate between joiner and lookup transformation?

1091

---

How do you load first and last records into target table?

1140

---

what is diff b/t sorter t/r and agg have the option sorter property...

2160

---

What is Index Caches size?

1092

---

What are the components of the workflow manager?

1116

---

Please let me know how to make Data masking in informatica..

1696

---

What is the benefit of partitioning a session?

1159

---

Is there any target staging area in informatica not staging area

2555

---

what is index?how it can work in informatica

2027

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1855

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2089

---

What is sequence generator transformation in informatica?

1056

---

tell me about your project functionality

2328

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1216

---