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 many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

what is Active lock explain

0 Answers   Satyam,

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---

What is a candidate key?

7 Answers   CTS,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

Parameter and variable differences

0 Answers  

---

What is the need of building a data warehouse?

2 Answers  

---