Answer Posted / rashid

data stage director > job > cleanup resources>
stateupid>job names> select the required job> click on log out
we unlock the job

if it is not work then we go for data stage administrator>
session management>active session

In session management you can find locked jobs there u can
select..

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

3719

---

What is the difference between passive stage and active stage?

1452

---

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

2840

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2694

---

Define repository tables in datastage?

1124

---

Name the different sorting methods in datastage.

1007

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3994

---

Define Job control?

1092

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3752

---

What are the job parameters?

1180

---

Why fact table is in normal form?

1166

---

What is the difference between informatica and datastage?

1173

---

Which warehouse using in your datawarehouse

2136

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2032

---

How many areas for files does datastage have?

1106

---