DSXchange

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.

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

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...

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