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

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

why dataset ?

2 Answers  

---

what is hash file

2 Answers   CTS, IBM,

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

what is meta data? Explain? Where it is used?

9 Answers  

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

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.

0 Answers  

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

How to manage date conversion in Datastage?

0 Answers  

---