Compilation errors

[sdfasih]

Hi,
Iam trying to load a fact table. One of the transformation rule states that
I do a look up on two tables which are other than the "source" and pull out
field(SID) and load it in the fact table(without any lookup from the source).
For that I did a lookup on those two tables and pulled out a field and loaded into a
hash file and linked it with the transformer that is loading the fact table.But
the field(SID) is shown red in the transformer and giving me compilation errors.
can anybody suggest a way to tackle this problem.
Thanx.

[narasimha]

Have you linked the Key coulmn in your lookup to your source compare column?

Give more information about the error if this does not help.

[sdfasih]

Hi,
Iam trying to load a fact table. One of the transformation rule states that
I do a look up on two tables which are other than the "source" and pull out
field(SID) and load it in the fact table(without any lookup from the source).
For that I did a lookup on those two tables and pulled out a field and loaded into a
hash file and linked it with the transformer that is loading the fact table.But
the field(SID) is shown red in the transformer and giving me compilation errors.
can anybody suggest a way to tackle this problem.
Thanx.

There is no lookup with the main source table thats the problem.

[Krazykoolrohit]

delete that row from the transformer and drag it again.

right click and "do validation" check what error it gives.

[urshit_1983]

You said without doing lookup with the source ???

And why you need to build a hashed file if the table itself can be used for the lookup.. More over I guess you are doing the same thing by building the hashed file and then using it as look up ..

So Correct me if i m wrong :

your job is like -

SourceTable->Transformer->OutputTable
^ ^
| |

Table1 Table2

Table1 and Table2 are for lookups correct ??

If this is so no need to build the hashed file. Unless its a huge data. Or you can build it in other job and take the hashed file in your this job. Its coming red because you must have set the Primary key and not linked with the source.

Hope this if fine exp.

[urshit_1983]

Sorry, due to formatting the Table1 and Table2 have moved to Source instead to Transformer.