Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

Explain Quality stage?

0 Answers  

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

what is the use of skid in reporting?

0 Answers   NTT Data,

---

How did you reconcile source with target?

2 Answers   HP,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

---

Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---