Answer Posted / rathdsetl@gmail.com

For example
Source1
c1
source 2
c2
soucr 3
c3
source 4
c5
source 5
c5





my target belongs to


target1
c1
target 2
c2
target 3
c3
target 4
c5
target 5
c5


This is dump date

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

781

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1747

---

What all the types of jobs you developed?

1181

---

What is the difference between an operational datastage and a data warehouse?

1155

---

How to read multiple files using a single datastage job if files have the same metadata?

1252

---

What are constraints and derivations?

1171

---

What is a merge in datastage?

1271

---

What are the differences between datastage and informatica?

1178

---

Notification Activity

1411

---

What is the importance of the exception activity in datastage?

1073

---

Nls stands for what in datastage?

1191

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2905

---

What are the various kinds of containers available in datastage?

1048

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

---