How to move data set from one server to other?what are the steps to follow to do this?
- 2 Answers
- 4043 Views
- I also Faced
- E-Mail Answers
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 |
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What is datastage engine?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
Is the value of staging variable stored temporarily or permanently?
What is the difference b/w Hash file and Lookup Fileset stages?
How do you start developing a datastage project?
If the job aborted in a sequencer, how can we start that from the previews successful job.
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
Can you implement SCD2 using join, transformer and funnel stage?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
Can you explain tagbatch restructure operator?
How many types of hash files are there?
Teradata 
