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.

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  

---

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

1 Answers   IBM,

---

How to display errors in datastage?

1 Answers   TCS,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

How a routine is called in datastage job?

0 Answers  

---

What are the different types of lookups in datastage?

0 Answers  

---

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---