inserting the diff files data in to target table

amreesh_singh · Post by **amreesh_singh** » Wed Sep 24, 2008 7:34 am

Hi,

The job have 3 sequential files , 1st one contains 4 columns and the 2nd one contains 5 columns and the 3rd one 2 columns.

All the seq. files contains diff. data with no common column.

There are 2 different target tables. 1st one contains total 6 columns ;4 columns of 1st seq file and 2 columns of 3rd seq file.

2nd target table contains total 7 columns;5 columns of 2nd seq. file and 2 columns 3rd seq. file.

File1 ------> Tran------> Oracle1
File2-------->Tran------>Oracle2

File3--------->???????
I tried to develop the job but the issue is that the transformer and oracle stage doesnt allow multiple inputs and File3 columns values is needed by both the oracle stages.
How to get it done.

chulett · Post by **chulett** » Wed Sep 24, 2008 7:38 am

Add two more Oracle stages. Link both from the 'third' transformer.

amreesh_singh · Post by **amreesh_singh** » Wed Sep 24, 2008 7:49 am

chulett wrote:Add two more Oracle stages. Link both from the 'third' transformer. ...

Thanks for the reply chulett . can you brief me on that , i could not get the point. I am having only two target tables and those are mapped to the two oracle stages.

chulett · Post by **chulett** » Wed Sep 24, 2008 7:53 am

Map them again. No rule against having multiple stages writing to the same instance / schema / table as long as you don't create locking issues. Or use another stage to combine the two streams before sending the data to Oracle.

amreesh_singh · Post by **amreesh_singh** » Wed Sep 24, 2008 9:46 pm

chulett wrote:Map them again. No rule against having multiple stages writing to the same instance / schema / table as long as you don't create locking issues. Or use another stage to combine the two streams before ...

Thanks

chulett · Post by **chulett** » Thu Sep 25, 2008 6:49 am

amreesh_singh wrote:But I need to update only records which i have inserted in to the table using 1st job.

First mention of more than one job or of this particular requirement.

How can you recognize the records inserted by the first job?

amreesh_singh · Post by **amreesh_singh** » Thu Sep 25, 2008 6:59 am

chulett wrote:
amreesh_singh wrote:But I need to update only records which i have inserted in to the table using 1st job.
First mention of more than one job or of this particular requirement.

How can ...

i need to update only those records with the file 2 column value which i have inserted in the table in job 1

chulett · Post by **chulett** » Thu Sep 25, 2008 7:05 am

You've said that already. Let's try this again.

How can you recognize the records inserted by the first job?

amreesh_singh · Post by **amreesh_singh** » Thu Sep 25, 2008 7:18 am

chulett wrote:You've said that already. Let's try this again.

How can you recognize the records inserted by the first job? ...

with the 4 column values inserted