Interested to Buy Any Domain ? << Click Here >> for more details...
Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18
How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.
- 7 Answers
- 10506 Views
- I also Faced
- E-Mail Answers
Answer Posted / shar
whats wrong with the people
see we have 3 targets so.,.
use below under tx constraints
mod(src,3)=1 move it to target1
mod(src,3)=2 move it to target2
mod(src,3)=0 move it to target3
seq-->tx-->dataset(3)
whats the big deal in it?
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How many types of stage?
Define orabulk and bcp stages?
How can you write parallel routines in datastage PX?
What is a merge in datastage?
What is the difference between operational data stage (ods) and data warehouse?
What is the difference between in process and inter process?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Explain usage analysis in datastage?
Differentiate between Join, Merge and Lookup stage?
What are stage variables, derivations and constants?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the important features of datastage?
project Steps,hits, Project level HArd things,Solved methods?
Explain datastage architecture?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
