Answer / ramesh

In DsMacro the function "DsJobstartDate " is there, by
using this we can recall sysdate

Answer / subhash

there many ways to get the SYSDATE:
1) By using the SYSDATE in the select query of your Oracle
Source.
2) By using the DsMacro, the function "DsJobstartDate " in
the transformer.
3) By using Date & Time function - "CurrentDate()" in the
transformer.
4) You would use the Date() function, and then some
variation of the OConv() function to change the date from
internal to external format.

For example, say you want to assign the current date to a
variable called StartDate, and format it in yyyy/mm/dd
format, you would use:

StartDate = Oconv(Date(), "D4/YMD")

Answer / kpk

if i were you i would use a function in the transformer stage.

Answer / palgun

CurrentDate()

U can find many more functions in the transformer stage....

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

0 Answers  

---

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers   HCL,

---

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

How do you reject records in a transformer?

0 Answers  

---

How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

---

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

CHANGE CAPTURE

0 Answers   CTS,

---

how many write modes are there in ds

2 Answers   IBM,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---