Answer Posted / loga

Hi,


Am using DS 8.5 and Oracle 11g.
I want to connect Oracle with Data stage with 'oracle connector' stage. I am getting error message connection failed. Can any one tel me how to connect these.... Am new Data stage, its highly appreciated if you given answer with snapshots. Regards, Loga

What is difference between join, merge and lookup stage?

1097

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3650

---

What are stage variables?

1202

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2024

---

I have a few records just I want to store data in to targets cycling way how?

2363

---

What is "fatal error/rdbms code 3996" error?

1266

---

What is the difference between the local container and shared container?

1103

---

Explain usage analysis in datastage?

1163

---

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...

4188

---

What is the purpose of pivot stage?

1168

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2233

---

Differentiate between hash file and sequential file?

1072

---

Can you explain players in datastage?

1199

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5122

---