Hi,
I have to call external routine in my DataStage job to perform certain transfermation matching and filter.
Is there any issue on performance while using these external routines?
Is there any impact on perf while calling external routines
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Mon Oct 13, 2008 1:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is your definition of "performance" in an ETL context? Without knowing this it is not possible to answer your question. And what would be your alternative if the answer were to be "yes"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3
- Joined: Mon Oct 13, 2008 1:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Compared to what?
Naturally there is an overhead in making the initial call, but it's negligible and only occurs on the first row (on each node). After that the routine's code is in memory and its entrypoint address is known.
Naturally there is an overhead in making the initial call, but it's negligible and only occurs on the first row (on each node). After that the routine's code is in memory and its entrypoint address is known.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.