regarding merge stage

[vijaykumar]

Hi gurus,
i want to merge 2 ODBC databases, but what i try to join two odbc stages, iam getting a message that merge doesn't support i/p links.
what i learned is merge works just like a join, but now why am i getting this type of peculiar message, plz help me to analyze the property.

cheers;
vijay

[narasimha]

With Merge stage you can merge only files.
Is it possible for you to merge the queries into a single one?

[I_Server_Whale]

If you are talking about 'Merge Stage'. Merge stage is used to join two files, this is clearly evident when you open the Merge stage as you can see it asks for 'First File Directory Path' and 'Second File Directory Path'.

You can get more info about this stage in DS help.

In your situation, you can use one of the ODBC stages as a lookup and perform a join. But you should consider the performance aspect with this way of doing things.

Whale.

[us1aslam1us]

I guess you learned something about Parallel Merge stage which is quite different from server merge stage, Here in you can define the files in the stage itself and i am quite sure you will be able to merge only files in server jobs. So the best bet for you will be Join stage.

Sam

[narasimha]

So the best bet for you will be Join stage.

AFAIK we don't have a Join stage in the Server edition.

[us1aslam1us]

oooops you are right! sorry vijay.

sam

[ray.wurlod]

Hi gurus,
i want to merge 2 ODBC databases, but what i try to join two odbc stages, iam getting a message that merge doesn't support i/p links.
what i learned is merge works just like a join, but now why am i getting this type of peculiar message, plz help me to analyze the property.

cheers;
vijay

What you learned relates to parallel jobs only.

In server jobs, you can only do "joins" two ways - in the database itself or using a Transformer stage to perform the lookups.