Answer / subbuchamala

This function returns number of days from source date to the given date.

DaysSinceFromDate(mylink.sourcedate, mylink.givendate)--->No of days.

Ex:
DaysSinceFromDate(“2014-06-10”,”2014-06-15”)= 5

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

What are the main features of datastage?

0 Answers  

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

What are system variables and sequencers in datastage

0 Answers  

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

How to reverse the string using unix?

0 Answers   CTS,

---

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

How did you reconcile source with target?

3 Answers   HP,

---

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

---