my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
Answer Posted / srikanth
hi
it is possible by using transform stage
select the function in that select the mathematical in that
select the mod function and run the job
you will get the answer
Thanks & regards
srikanth.k
9573056597
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Where the datastage stored his repository?
What is the difference between orabulk and bcp stages?
What is the difference between datastage and datastage tx?
How to implement complex jobs in data stage?
How can we improve performance of data stage jobs?
Describe routines in datastage? Enlist various types of routines.
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What steps should be taken to improve Datastage jobs?
Can you explain link buffering?
Define Merge?
Can you filter data in hashed file?
What are the functionalities of link partitioner?
What are the types of containers?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE