Answer Posted / varma

As a developer you cannot find it unless you have CREATE_TS column in the table. Its always a best practice to have this column which records timestamp.

DBAs can find out in several ways (Tracing etc) but its not a straight forward way

Explain datastage architecture?

1336

---

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

3701

---

How do u convert the columns to rows in datastage?

1142

---

Define oconv () and iconv () functions in datastage?

1343

---

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?

1452

---

how to write server Routine coding?

2063

---

Where do the datastage jobs get stored?

1150

---

How do you remove duplicate values in datastage?

1097

---

What is the use of hoursfromtime() function in transformer stage in datastage?

1001

---

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

2822

---

What is a datastage job?

965

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1834

---

Can you explain tagbatch restructure operator?

1118

---

What are the areas of application?

1092

---

Difference between sequential file and data set?

1136

---