Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7640 Views
- I also Faced
- E-Mail Answers
Answer Posted / pranay
____tgt1
|
|
source------transformer---
|
|
-----tgt2
in transformer
TGT1 ---
constraint --> mod(deptno,2) = 1
source.deptno - deptno
source.sal - sal
TGT2 ---
constraint --> mod(deptno,2) = 0
derivation -->
source.deptno - deptno
source.sal - sal
u'll get the ans, if i'm wrong plz correct me
| Is This Answer Correct ? | 6 Yes | 11 No |
Post New Answer View All Answers
Can you explain tagbatch restructure operator?
what are the devoleper roles in real time? plz tell i am new to datastage....
How do you schedule or monitoring the job?
Nls stands for what in datastage?
Explain how a source file is populated?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the difference between informatica and datastage?
What is apt_config in datastage?
What is the flow of loading data into fact & dimensional tables?
What are the benefits of datastage?
What is the project in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the difference between odbc and drs stage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
How we can covert server job to a parallel job?
