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
- 7653 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
What is the purpose of interprocessor stage in server jobs?
how to write server Routine coding?
What are the enhancements made in datastage 7.5 compare with 7.0?
How do you generate sequence number in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the steps needed to create a simple basic datastage job?
What are the types of jobs we have in datastage?
What is meta stage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How and where you used hash file?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between hashfile and sequential file?
Give an idea of system variables.
How one source columns or rows to be loaded in to two different tables?
