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
- 6581 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari chowdary
by using partition technique round rabin we can do easily.
single source table,two target tables
| Is This Answer Correct ? | 16 Yes | 1 No |
____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 |
What is ds designer?
What are the different options associated with dsjob command?
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?
Define data aggregation?
i have flat file and using unix how can i generate sequence number into targer?
What are routines in datastage?
What all are the different way to run a job?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
What is the differentiate between data file and descriptor file?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
What is staging variable?
What is a range lookup?
Teradata 
