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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
CHANGE CAPTURE
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the difference between odbc and drs stage?
what is flow of project?
In Datastage, how you can fix the truncated data error?
Where do the datastage jobs get stored?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Describe stream connector?
Define Data Stage?
What are the components of ascential data stage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Describe the main features of datastage?
What are the repository tables in datastage?