Answer Posted / amedela chandra sekhar

BY USING NORMALIZER T/R WE CAN ACHIEVE THIS SCENARIO.








I hope i have given right solution.

How can a transformation be made reusable?

1223

---

What is rank transformation in informatica

1230

---

What is decode in static cache?

1259

---

What is the need of etl tools?

1178

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7365

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

---

Define mapplet?

1057

---

Explain in detail scd type 2 through mapping.

1088

---

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

2156

---

What is dimensional table? Explain the different dimensions.

1244

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2352

---

how to load dimension table and fact table. plz tell me the steps.

2140

---

Can u generate reports in Informatica?

1142

---

How to generate sequence numbers without using the sequence generator transformation?

1252

---

What is an expression transformation in informatica?

1088

---