Answer Posted / madhav

hi can u explain in depth

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2868

---

How to Remove Duplicate using SQL?

1373

---

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

---

CHANGE CAPTURE

1311

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4190

---

What is the difference between passive stage and active stage?

1543

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1161

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1090

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1556

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3759

---

what is the use of surogate key in datastage

2312

---

Define meta stage?

1208

---

how to export or import the jobs in .ISX file

1205

---

in oracle target stage when we use load option and when we use upsert option?

2285

---