Answer Posted / amedela chandra sekhar

S.D--->S.Q....>EXP T/R......>TGT


In exp t/r create one out put port give condition
by using Replace function we can achieve this scenario.

or sql query :

select replace('1:2;3','1:2;3','123') from dual;
ans:

REP
---
123

What the difference is between a database, a data warehouse and a data mart?

1155

---

What is xml source qualifier transformation in informatica?

1217

---

What is the benefit of partitioning a session?

1182

---

difference between repository database and repository service?

1152

---

What do you mean by filter transformation?

953

---

Explain pmcmd command usage in informatica

1136

---

What is a difference between complete, stop and abort?

1083

---

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

---

How can you generate reports in informatica?

1035

---

Repository user profiles

1763

---

What are mapplets? How is it different from a Reusable Transformation?

1092

---

State the limitations where we cannot use joiner in the mapping pipeline?

1067

---

What is complex mapping?

1122

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

draw informatica architecture 8.6 ?

3873

---