It is currently 14 Dec 2017 3:30


Post new topic  Reply to topic  [ 10 posts ] 
Author Message
 Post subject:
PostPosted: 16 Feb 2007 3:39 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 696
Location: PARIS
Hi,

I don't know anything about Informatica WorkFlow.
So, as some other tools as GENIO for example you can invoke in Command Line some order.

If all your treatment is managed only by Informatica it will be difficult to build a scenario with Control-M.

The most important will be to split your treatment as a single step and launch with a Control-M job each of them and detect exit code more easily.

In your case :
Job 1 to extract from Sybase
Job 2 to load data in Orcale
and different other jobs to start dataserver or to relaunch extraction in cas of Job 1 exit with an error different of 0.

I hope to have helped you.


Top
   
 Post subject:
PostPosted: 11 Jun 2007 4:05 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
de toute fa?on l'import / export peut ?tre ind?pendant du type de base non?
si j'utilise ecs util / import_def_table ... j'ai les m?mes utilitaires pour oracle non ?


Top
   
 Post subject: philmalmaison
PostPosted: 11 Jun 2007 4:12 
Mozes pisat anglicky?
Tiez mozem pouzivat materinsky jazyk, ale asi to pre viacerych nebude uzitocne.
Nemyslis?
----
can you write in English please?
I can use my native language too, but it wont be helpfull for most peoples. Don't you think?


Top
   
 Post subject:
PostPosted: 11 Jun 2007 4:28 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 696
Location: PARIS
Hi philmalmaison

Be carefull about your answer.
That post didn't concern jobs defintion extraction between sybase and oracle.

It concerned some possibilities to extract applicative data from a sybase dataserver to an oracle dataserver.


Top
   
 Post subject:
PostPosted: 28 Jun 2007 5:46 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
so what is about the control-m in this question ... ? ...


Top
   
 Post subject: Hi ravikumar,
PostPosted: 14 Dec 2007 1:12 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Nov 2007 12:00
Posts: 76
Location: Hyderabad
I am sorry to go out of the topic and ask you, but I am curious to know that where do you work? becasuse your name sounds like indian and I am new to Control-M , so I want to know where else Control-M is being used.


Thanks&Regards
sharaschandra


Top
   
 Post subject:
PostPosted: 16 Dec 2007 12:04 
Offline
Nouveau
Nouveau
User avatar

Joined: 13 Nov 2007 12:00
Posts: 76
Location: Hyderabad
Hi Ravikumar, we use Ascential datastages as ETL tool, what we generally do in + testing is , just trigger the ETL job from Control-M job using some unix shell scripts and see if it is triggering the ETL job and getting the perfect return codes back in the SYSOUT. And in -VE testing we trigger the job in the same way and then kill the job to see if it is getting killed and make sure all the shouts are performed..

thanks,


Top
   
 Post subject:
PostPosted: 20 Dec 2007 3:04 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
doesn't matter to ctrlm how to extract, then upload, why are you searching that kind of experience here ? ...

any data migration process depend of the context no ?

regards
Philmalmaison


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 10 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved