inserting the diff files data in to target table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
inserting the diff files data in to target table
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.
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.
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
First mention of more than one job or of this particular requirement.amreesh_singh wrote:But I need to update only records which i have inserted in to the table using 1st job.
How can you recognize the records inserted by the first job?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
i need to update only those records with the file 2 column value which i have inserted in the table in job 1chulett wrote:First mention of more than one job or of this particular requirement.amreesh_singh wrote:But I need to update only records which i have inserted in to the table using 1st job.
How can ...
-
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am