Post reply

Pulling child records for each parent record retrieved

  • December 5, 2008 at 11:03 am

    #126190

    I'm writing an integration package to link two systems. I am retrieving parent records from one database and want to retrieve their corresponding child records from another database.

    I thought I could use the Lookup tool, but there's more than one child record for each and the Lookup only returns the top row.

    Additionally, I tried a Merge/Merge Join, but in order to do so, I have to retrieve the entire second dataset (50k rows) of which only 600 rows match the primary keys in the parent records in question.

    So, is there an efficient way to get all the child rows for each parent row in a data source?

    Thanks all!

    Jay

  • December 5, 2008 at 11:24 am

    #908559

    A merge join is usually fastest, but if you have a really large table and only need a few records, you really need to use a script component and query for each individual key you need records for.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply