Inserting records in form of groups
Posted: Thu Jan 23, 2014 6:14 pm
I have a requirement where I need to send records in groups to the table.
Below is the example
Name Phone Acct
ABC 123 111
DEF 456 111
GHI 789 333
JKL 712 222
MNO 765 222
the input from the source is this and I need to send only records which have same account number at a time like 111 has 2 records, 222 has 2 records and 333 is 1 record. So the first 2 records should go and they have some transformations to be taken care which will handle only same account number records and after the transformations they get inserted into the table. Next the other group with 222 acct no has 2 records so they should do the transformations and then get loaded after the 111 and later 333. So each group having same account number should travel until the target following all the transformations and get inserted into the table.
Please suggest me any solution, thank you
Below is the example
Name Phone Acct
ABC 123 111
DEF 456 111
GHI 789 333
JKL 712 222
MNO 765 222
the input from the source is this and I need to send only records which have same account number at a time like 111 has 2 records, 222 has 2 records and 333 is 1 record. So the first 2 records should go and they have some transformations to be taken care which will handle only same account number records and after the transformations they get inserted into the table. Next the other group with 222 acct no has 2 records so they should do the transformations and then get loaded after the 111 and later 333. So each group having same account number should travel until the target following all the transformations and get inserted into the table.
Please suggest me any solution, thank you