Answer Posted / venkat

here lkp transformation is perform left outer join only.
it will display matching and non matching records,but in
case of non matching(while using conn lkp)records return
default value.while using unconn lkp returns null value.

How many transformations can be used in mapplets.

1937

---

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

2110

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What do you mean by channel change?

1051

---

What is a sorter transformation?

1102

---

What is a difference between complete, stop and abort?

1085

---

How to update a particular record in target with out running whole workflow?

1576

---

What are the performance considerations when working with aggregator transformation?

1154

---

What is the function of union transformation?

1136

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2009

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160

---

What are roles and groups and benefits of using them?

1057

---

What is aggregate cache in aggregator transformation?

1147

---

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

1159

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015

---