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
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
How can you write parallel routines in datastage PX?
What is the difference between odbc and drs stage?
How do you run datastage job from the command line?
client know skid info?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the types of views in datastage director?
How rejected rows are managed in datastage?
What are orabulk and bcp stages?
Give an idea of system variables.
What are the main features of datastage?
What are the job parameters?
Define orabulk and bcp stages?
What is the project in datastage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
To see hidden files in LINIX?