Details Mercator Execution flow

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
nike_ravi
Participant
Posts: 17
Joined: Sun Feb 20, 2005 11:23 pm
Location: Chennai

Details Mercator Execution flow

Post by nike_ravi »

Hi,

Any body can give the whre i can get details abt
1.Where are the maps, tree going store.Is TX using its own database for storing its components? or Is it save as some other format/file.
2. If i create a typical job run then wht is flow of the job.
3. Wht are extra features comparing with DS and other ETL tool

I installed TX in my systm if know in wich document can i get this info.
Appriciate ur help.

-Rav! Nemalipuri


[color=darkblue][/color] :?:
sachinkc
Participant
Posts: 34
Joined: Sat Apr 17, 2004 11:39 am
Location: USA

Re: Details Mercator Execution flow

Post by sachinkc »

Ravi,
TX is "not really" an ETL tool, its a good translation tool with integration plugins for various systems. I think a good starting doc for you might be typetree maker and map designer doc.
It saves those in some other non human readeable format in files (atleast till v6.7).
- Sachin
nike_ravi wrote:Hi,

Any body can give the whre i can get details abt
1.Where are the maps, tree going store.Is TX using its own database for storing its components? or Is it save as some other format/file.
2. If i create a typical job run then wht is flow of the job.
3. Wht are extra features comparing with DS and other ETL tool

I installed TX in my systm if know in wich document can i get this info.
Appriciate ur help.

-Rav! Nemalipuri


:?:
Rgrds & Cheers!

Sachin
sachin@operamail.com
~Life always finds a way~
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

That's assuming pdf files can be read by non humans.

Type trees are held in files with extension .mtt
Map sources are held in files with an extension .mms
Compiled maps are held in files with extension .mmc

Mercator maps can be run under the command server 1 at a time or under the event server and controlled by system files created in the integration flow designer. The flow is determined by what you want to do.
Maps can be triggered by a time event or a data event etc.

all the documentation is supplied as pdf files and there is a tutorial as part of the installation.
nike_ravi
Participant
Posts: 17
Joined: Sun Feb 20, 2005 11:23 pm
Location: Chennai

Post by nike_ravi »

Thanks for Ur info sachinkc and janhess.

I developped and ran few exapmples which are given in tutorial.


If i given the build command.Process flollow the way like

First it checks for missing rules
then for invalid rules
then for invalid card definitions
Verifying map references
Verifying the arguments of functions etc.

Where it will chek abt map refences. It should go some where like database or reposotiry. Where it is?

What proces will it follow after i click RUN buttion for particular Map?


Can any one of U give Scenario where can i use this tool? For what type of projects this tool is suitable?

Once again Thanks for ur reply

Rav! Nemalipuri
janhess
Participant
Posts: 201
Joined: Thu Sep 18, 2003 2:18 am
Location: UK

Post by janhess »

It's a data transformation tool. It gets data from an input source and sends it to an output source which can have a different format.
EG read messages from a JMS queue, change the structure to a SWIFT massage and sent it to SWIFT.
Read a database table, reformat the data to an new layout and sent it to a spreadsheet.
The options are endless.

I don't understand your question about map references. There are no databases. There is a resourvce registry which can hold information which is dynamically resolved at map ru. time.

You really need to read the documentation and do the tutorial. Also look at the example maps in the Examples folder - these cover most of the adapters you will use.
sachinkc
Participant
Posts: 34
Joined: Sat Apr 17, 2004 11:39 am
Location: USA

Post by sachinkc »

You might be confusing it with the ETL version. They are two different species sent to this earth by the same Ascential (now probably IBM) God.

There is no repository database against which it checks, the "database" is that particular map file which you are trying to run\test.
Used for Any format to Any format transformations, with interfaces setup to various system plugins.
Go through the help docs, or attend a training session.

- Sachin
nike_ravi wrote:Thanks for Ur info sachinkc and janhess.

I developped and ran few exapmples which are given in tutorial.


If i given the build command.Process flollow the way like

First it checks for missing rules
then for invalid rules
then for invalid card definitions
Verifying map references
Verifying the arguments of functions etc.

Where it will chek abt map refences. It should go some where like database or reposotiry. Where it is?

What proces will it follow after i click RUN buttion for particular Map?


Can any one of U give Scenario where can i use this tool? For what type of projects this tool is suitable?

Once again Thanks for ur reply

Rav! Nemalipuri
Post Reply