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
- 6610 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 |
How do you reject records in a transformer?
how does work server jobs?
What are the different type of jobs in datastage?
What are the benefits of datastage?
How did you reconcile source with target?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
What is PX?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
Hi Vijay here For Four CPU's how many nodes will required?
How can we improve performance of data stage jobs?
Teradata 
