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
- 7537 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
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Describe link sort?
What are some different alternative commands associated with "dsjob"?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the components of datastage?
Which warehouse using in your datawarehouse
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Have you have ever worked in unix environment and why it is useful in datastage?
I have a few records just I want to store data in to targets cycling way how?
What are the components of ascential data stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How do you remove duplicate values in datastage?
What are the functionalities of link partitioner?
Name the command line functions to import and export the DS jobs?
What are stage variables and constants?
