JoinStageProblem

skp · Post by **skp** » Mon Feb 18, 2008 5:07 am

Hi,

In Join Stage -->can we do join on two different databases tables(Oracle and SQL Server0
I am trying to do but I am getting
Error:
Sort key field not found:

In the join Stage it is not populating any Fields ???

Please let me know how can I resolve

Regard
skp

ArndW · Post by **ArndW** » Mon Feb 18, 2008 5:29 am

Is the key column present as a key? Is it present in both links? Did you declare the "key" in the join stage?

skp · Post by **skp** » Mon Feb 18, 2008 5:52 am

Thanks Andrw

Oracle field FundGroupNumber(Field) is not specified as key in the oracle table.

MSSQLServer field FundGroupNumber(Field) is sepecified as key at SQLServer Table.

In datastage at OracleEnterprizeStage I made 'FundGroupNumber' as key.

In Join Stage at key dropdown it will populate all fieds automatically.

But I am not getting any fields in the drop down.I Declare it by hardcodeing.

skp · Post by **skp** » Mon Feb 18, 2008 6:00 am

Can we jon two different databases(Oracle and SQLServer) tables ?

Maveric · Post by **Maveric** » Mon Feb 18, 2008 7:17 am

You can join. your key columns should have the same name. Identify the key fields in both the links. Keep the key field names in one of the link same and change the field names for the other link. Then you will see that the drop down is populated. Select the fields from the drop down. Do the renaming in a copy, modify or transformer stage.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 3:35 pm

The Join keys must not only have the same name, they must also have the same data type.

sajarman · Post by **sajarman** » Mon Feb 18, 2008 3:43 pm

Just a thought - check if the column names have same case (both capital or small).

Hope you resolved the problem.

skp · Post by **skp** » Mon Feb 18, 2008 10:23 pm

have 1 to many relations between the two tables ,while performing join stage it thrwoing an error .

skp · Post by **skp** » Mon Feb 18, 2008 10:28 pm

have 1 to many relations between the two tables ,while performing join stage it thrwoing an error .

balajisr · Post by **balajisr** » Mon Feb 18, 2008 10:41 pm

skp wrote:have 1 to many relations between the two tables ,while performing join stage it thrwoing an error .

What Error

ray.wurlod · Post by **ray.wurlod** » Mon Feb 18, 2008 11:31 pm

sajarman · Post by **sajarman** » Tue Feb 19, 2008 10:38 am

Are you getting the error at runtime or during compilation?

sajarman · Post by **sajarman** » Tue Feb 19, 2008 10:39 am

Have you selected Auto for partition in the join stage or have you repartitioned the input data?