attachment etl build for review

times29 · Post by **times29** » Fri Oct 03, 2008 5:01 pm

hi there,
i asked this question before too but still cant figure how to do it.
Can i attach my job and expert can have a look where i am wrong if possible,Can you please give step by step instruction how to attach to this
forum as i cant see any easy attachment button

thanks

chulett · Post by **chulett** » Fri Oct 03, 2008 5:13 pm

There's no "attachment" option here, or a place to upload files. You can, if you like, upload a screenshot of the canvas to any of the free filesharing sites out there and then include a link to it here using the "Img" or image tags.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 6:08 pm

You can use attachments at IBM DeveloperWorks though that site is not as busy as this one - on the other hand more IBM people browse there (they are encouraged to do so).

times29 · Post by **times29** » Fri Oct 03, 2008 7:03 pm

Hi there,
Heres the link
Problem is on change capture
this is star schema with dimensions as lookup based on business keys
and populating fact table

http://s450.photobucket.com/albums/qq22 ... 3081658023

and

http://s450.photobucket.com/albums/qq22 ... 3082188838

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 7:24 pm

You have offered no indication as to what the actual "problem" is. What are you trying to achieve, what are the expected results and what are the actual results? Perhaps provide a row or three of sample data from the inputs and the output if you're convinced that the "problem" (whatever it is) is in the Change Capture stage.