Answer / subhrangshu

When we are logging into Informatica repository for the First Time, the Metadata is getting imported into the Repository. This is why from the second time, we don't need to provide username & database or domain name. Only for authentication purpose, we have to provide the password.

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

What is a pre-defined event and user-defined event?

0 Answers  

---

---

disable caching in a lookup transformation?

1 Answers  

---

without update strategy how to insert &update?

1 Answers   DELL,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

What is surrogate key?

9 Answers  

---