Answer Posted / vamsi

hi,
u r absalutely write
but here the question is to retrive the empno also.....

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2356

---

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

3739

---

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

2711

---

Differentiate between hash file and sequential file?

1051

---

client know skid info?

2067

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2602

---

What are the functionalities of link partitioner?

1005

---

Where the datastage stored his repository?

1074

---

Differentiate between datastage and informatica?

1171

---

sed,awk,head

1447

---

What are the differences between datastage and informatica?

1162

---

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

2232

---

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

1250

---

project Steps,hits, Project level HArd things,Solved methods?

2107

---

how many rows sorted in sort stage by default in server jobs

3984

---