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
- 10332 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 can we create rank using datastage?what is the meaning of rank?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
root tree will find which is server job and which is parallel job?
What are the steps needed to create a simple basic datastage job?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Describe the architecture of datastage?
what is use of SDR function?
EXPLAIN SCD
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How can you write parallel routines in datastage PX?
What are the areas of application?
What are the functionalities of link partitioner?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
