How to move data set from one server to other?what are the steps to follow to do this?
Answers were Sorted based on User's Feedback
First why you want to do that ?
You can try this -
Design a job like -
dataset1 -> copy -> dataset2
server1 and server2 should be connected
Bind server1 config file with first one and second with second dataset
But, this will not gurantee that data will be transferred successfully.
Thanks
www.datagenx.net
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vijay
by using ORCH ADMIN commands we can move datasets from one location to another location
| Is This Answer Correct ? | 0 Yes | 0 No |
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
How we can covert server job to a parallel job?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
what is combinability and non combinability?
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
EXPLAIN SCD
What is RCP?
how to convert rows into columns
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
client know skid info?
can explain wt is the pool for file.
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)