FAct TABLE LOOKUPs data

Hi,

Please help me out in loading the fact tables

I had used lookup on DIM table to get my SUK and if I use union transformation to get the out put from each lookup and then loading the data with some condition the data in my fact is not loading in a proper format.

The union transformation is splitting the out put in to different records

Please do inform me about which transformation should be used to get the data from lookup tables.

Or please do inform me the approach to load the fact table in SSIS.

I’m basically INFORMATICA resource and I’m implementing in terms of INFORMATICA

First of all, In SSIS you don't link ports(columns) separately; you link component input and outputs. The Dataflow should look like:

Source Component -->LKP1(get Dim1 SUK) -->LKP2(get Dim2 SUK) -->LKn(getDimn SUK) ...-->Destination Component

Notice you may want to configure the Lookup error output to either redirect or ignore errors as this component treats the no matches as errors.

In the first page of this forum there is a webcast that shows a similar approach:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=534505&SiteID=1

Please post back if something is not clear.

|||

Thank you for that information.

please do clarify me on the approach i had taken

the dataflow in my mapping is :

Source Component >LKP1 > LKP2 > Union Component > SCD Component > Destination Component.

i know the union component is a problem in my mapping but instead of union what component do i use. i'm trying to find out this solution.

or if possible give me your approach for fact tale load with lookup components

Thank you

|||Instead of a UNION, try connecting the output from Lookup 1 to Lookup 2 directly. If you do that, you don't need a union.|||

Sheikh Mohammed wrote:

Thank you for that information.

please do clarify me on the approach i had taken

the dataflow in my mapping is :

Source Component >LKP1 > LKP2 > Union Component > SCD Component > Destination Component.

i know the union component is a problem in my mapping but instead of union what component do i use. i'm trying to find out this solution.

or if possible give me your approach for fact tale load with lookup components

Thank you

AS John says, you don't need the UNION all component at all because you have single pipeline; that is the same concept that in Informatica I belive