Answer Posted / john coder

i believe, we need an aggregator to pick up the last row for
a particular deptno.

Otherwise, there will be three rows inserted...

col1 col2
101 1000
101 1000,1500
101 1000,1500,2000

by having an aggregator with groupby on col1, we can pick up
the last row by either using LAST or MAX.

What is substr in informatica?

663

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1502

---

How to partition the Session?

648

---

What are the components of Informatica? And what is the purpose of each?

624

---

What are the tasks that source qualifier perform?

633

---

---

Do you find any difficulty while working with flat files as source and target?

676

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1465

---

Explain the different kinds of facts.

566

---

What is the function of aggregator transformation?

579

---

permutations of mapplet

2038

---

What is a surrogate key?

563

---

What is repository manager?

538

---

What is mapplet in informatica?

598

---

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

1696

---

What do you mean by blocking transformation?

585

---