Answer / ram

As Kiran said you call in sorce query..

Define pDate as jobparameter..
In Query ..
Ex:
Select loc,div from xxx where dim_t = '#pDate'

Answer / kiran

yes u can define date parameter as variable and call in
source query.

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

root tree will find which is server job and which is parallel job?

0 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,

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,

---

Where do the datastage jobs get stored?

0 Answers  

---

State the difference between an operational datastage and a data warehouse?

0 Answers  

---

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,

---

What steps should be taken to improve Datastage jobs?

0 Answers  

---