Test case scenarios needed for control M jobs

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 16 Feb 2007 3:39

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.

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 11 Jun 2007 4:05

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 ?

hipikll

philmalmaison

Post by hipikll » 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?

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 11 Jun 2007 4:28

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.

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 28 Jun 2007 5:46

so what is about the control-m in this question ... ? ...

User avatar
sharas
Nouveau
Nouveau
Posts: 76
Joined: 13 Nov 2007 12:00
Location: Hyderabad
Contact:

Hi ravikumar,

Post by sharas » 14 Dec 2007 1:12

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

User avatar
sharas
Nouveau
Nouveau
Posts: 76
Joined: 13 Nov 2007 12:00
Location: Hyderabad
Contact:

Post by sharas » 16 Dec 2007 12:04

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,

User avatar
philmalmaison
Nouveau
Nouveau
Posts: 1148
Joined: 08 Jun 2007 12:00
Location: Ile de France

Post by philmalmaison » 20 Dec 2007 3:04

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

Post Reply