Can any one help to solve the problem ...............

narasimhareddy · Post by **narasimhareddy** » Mon Mar 06, 2006 7:59 am

Hi,

I have flat file (source) contains fields like city,country,... .
Target dimention table (country) contains fields like country,city,... and so on.
In my source field country, some times empty.... if it is an empty i have to identify the country for that corresponding city field, then i have to pass data in to the dimention table.

Regards,
Reddy.

DSguru2B · Post by **DSguru2B** » Mon Mar 06, 2006 8:12 am

In order to solve this problem you need to have a look-up of City to Country (Code or Name). From the transformer filter those rows by having the logic
IF Link ISNULL
and store it in a Dataset.
Then use that dataset to lookup into the City to Country data set that is provided to you.
That should solve the issue. :D

chulett · Post by **chulett** » Mon Mar 06, 2006 8:12 am

Can you not create a dataset keyed by city with the country it is in as the data element? Then you can look it up on the way in and use it if the original value is null. Only problem with that would be when the same city name is in multiple countries...

kumar_s · Post by **kumar_s** » Mon Mar 06, 2006 10:19 am

Do a lookup on City.
In the Conditon option of the reference data, check for country = Null.