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.
Answer Posted / chandra swain
source-->transformersatage--->dataset1
---->dataset2
----->dataset3
double click on transformerstage,copy the input to output link
i.e(dataset1,dataset2,dataset3),then go to constraint part of the transformer stage ,we will find three constraint tabs,
in 1st constraints tabs write down--> column=1orcolumn=2orcolumn=3orcolumn=10orcolumn=11orcolumn=12
then go to 2nd constraints tabs --->write similarly
column=4orcolumn=5orcolumn=6orcolumn=13orcolumn=14orcolumn=15
,then go to 3rd constraints tab and click on otherwise/Log
go to dataset1,click on partitioning tab,select partition type:=hash,then click on check box(i.e perform sort)..
similarly ,go to dataset2,dataset3,and mention all the above technic...
i hope u got solun......
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Define repository tables in datastage?
What is the difference between operational data stage (ods) and data warehouse?
What are the various kinds of the hash file?
How to RD using transformer?
What steps should be taken to improve Datastage jobs?
how can we create rank using datastage?what is the meaning of rank?
How can you write parallel routines in datastage PX?
what is use of SDR function?
How to perform incremental load in datastage?
What are the different types of lookups in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the various kinds of containers available in datastage?
How will you move hashed file from one location to another location?
Where do the datastage jobs get stored?
Differentiate between datastage and datastage tx?