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
- 7503 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
Can you explain link buffering?
Can you highlight the main features of ibm infosphere information server?
Can you filter data in hashed file?
How do you schedule or monitoring the job?
Differentiate between hash file and sequential file?
How to implement complex jobs in data stage?
What are the different kinds of views available in a datastage director?
Explain the importance of surrogate key in data warehousing?
Where the datastage stored his repository?
What is job control?
What are the some differences between 7.x and 8.x version of datastage?
What are the various kinds of containers available in datastage?
Difference between server jobs & parallel jobs?
What are the differences between datastage and informatica?
Explain entity, attribute and relationship in datastage?
