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 |
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
What is a range lookup?
how to closeing records after 10,000 records come?
Can aggregator and transformer stages use to sort the data? How ?
when we have to go for a sequential file stage & for a dataset in datastage?
Define ds designer?
why do u need the IOS upgradation in a FC switch
What is the difference between passive stage and active stage?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
What is apt_config in datastage?
what is .dsx files
what r the sources u need to create the datastage?