Answer Posted / 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")

What is the roundrobin collector?

877

---

sed,awk,head

1237

---

Can you filter data in hashed file?

3582

---

How do you register plug-ins?

781

---

Define Job control?

864

---

What is aggtorec restructure operator?

1125

---

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?

2023

---

Define orabulk and bcp stages?

919

---

AGGREGATOR default datatype

1174

---

What are system variables and sequencers in datastage

870

---

Can you explain kafka connector?

1064

---

What is the difference between datastage and datastage tx?

836

---

Have you have ever worked in unix environment and why it is useful in datastage?

932

---

Define Routines and their types?

870

---

EXPLAIN SCD

1179

---