Answer Posted / kiran

1)how to clear the source file?
Ana:by using 3rd Party tool u can clear the source
2) diff b/t odbc & Oracle?what is node?
Ans:Node: its used to split the data into its memory location
3) explain one complex job u face in ur project

Can you implement SCD2 using join, transformer and funnel stage?

1091

---

Why do we use link partitioner and link collector in datastage?

685

---

What are the various kinds of containers available in datastage?

567

---

What is active and passive stage?

880

---

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

3314

---

---

what is the use of materialized view?

964

---

Define Job control?

679

---

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?

2052

---

How to reverse the string using SQL?

894

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

970

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1049

---

Differentiate between odbc and drs stage?

593

---

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

1753

---

What is the difference between server job and parallel jobs?

672

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2121

---