Hi,
We are basically writing into an Oracle Enterprise stage, source is Sequential file stage. We need to find out selected row count and seprate inserted row count and update row count into target table.
I think GetlinkInfo function is not feasible option to achieve this.. as this gives only the row processed through the link.
can anyone suggest anyother datastage function to achieve this?
Thanks
Getting Insert and Update rows count
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Thu Jul 29, 2004 1:03 pm
I assume you are using an upsert mode in the current job and hence cannot identify the rows that you are inserting/updating. One option is, you can seperate the inserts and updates. Once seperated you can have two jobs, one that inserts and another that updates. This will allow you to use the GetLinkInfo
Thanks,
Shekar
Thanks,
Shekar
The same thing can be accomplished in one job.
Use a lookup to determine which rows are inserts.
Then seperate your links...one for insert...the other for update.
The info you need will then be available.
Use a lookup to determine which rows are inserts.
Then seperate your links...one for insert...the other for update.
The info you need will then be available.
Lance Short
"infinite diversity in infinite combinations"
***
"The absence of evidence is not evidence of absence."
"infinite diversity in infinite combinations"
***
"The absence of evidence is not evidence of absence."
-
- Participant
- Posts: 5
- Joined: Wed Apr 20, 2005 6:29 pm
- Location: USA
Re: Getting Insert and Update rows count
I think using the change capture stage will solve this.
Thanks,
Kiran Kumar Reddy
Kiran Kumar Reddy