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
- 7648 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 the difference between the local container and shared container?
How one source columns or rows to be loaded in to two different tables?
How to convert table data into xml file using xml output stage? please explain step by step;
Can you explain players in datastage?
options available in sequence job to run,validate?
What is the difference between datastage and datastage tx?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the difference between server job and parallel jobs?
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
What is ds designer?
Teradata 
