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....

How to Convert the columns into rows?

2 Answers  

---

what is the definitions for Datawarehose and Datamart?

4 Answers  

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

what is initial load and incremental load

3 Answers   ADP,

---

What are the types of hashed files in data stage

0 Answers  

---

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

---

What are the different type of jobs in datastage?

0 Answers  

---

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

2 Answers   Infosys,

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

---

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

---

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---