Hi,
How to make connectivity for Peoplesoft EPM from Datastage
thanks
vbeeram
Connectivity
Moderators: chulett, rschirm, roy
Connectivity
Last edited by vbeeram on Mon Feb 21, 2005 1:35 pm, edited 6 times in total.
Have you searched this forum? It's covered a lot and you have to be more clear about how you're needing to implement one (type 1, 2, 3, modified 1/2/3, etc)
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Hallo vbeeram
The best way to handel a record that changes slowly over time is to use the checksum function - its much better than doing an AND..OR statement that is tedious to type and difficult to manage.
From Help:
So.. if you have the stream CheckSum value and you compare it to the reference Checksum value, you will get the different values. Just be sure to match the correct columns, otherwise everything is a changed record!
This is one way to do it though - as kcbland said; there are many topics on this subject in the forum.
The best way to handel a record that changes slowly over time is to use the checksum function - its much better than doing an AND..OR statement that is tedious to type and difficult to manage.
From Help:
Code: Select all
This example uses the Checksum function to return a number that is a cyclic redundancy code for the specified string.
MyString = "This is any arbitrary string value"
CheckValue = Checksum(MyString) ;* returns 36235
This is one way to do it though - as kcbland said; there are many topics on this subject in the forum.
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
"what the thinker thinks, the prover proves" - Robert Anton Wilson
Thanks
"Thanks I got it now"
denzilsyb wrote:Hallo vbeeram
The best way to handel a record that changes slowly over time is to use the checksum function - its much better than doing an AND..OR statement that is tedious to type and difficult to manage.
From Help:
So.. if you have the stream CheckSum value and you compare it to the reference Checksum value, you will get the different values. Just be sure to match the correct columns, otherwise everything is a changed record!Code: Select all
This example uses the Checksum function to return a number that is a cyclic redundancy code for the specified string. MyString = "This is any arbitrary string value" CheckValue = Checksum(MyString) ;* returns 36235
This is one way to do it though - as kcbland said; there are many topics on this subject in the forum.
Hi vbeeram,
There are seval methods for handling SCD's. But we have used the CDC stage for handling SCD's. Pls folow this link.
viewtopic.php?t=87740
It will give you more information.
HTH.
--Rich
There are seval methods for handling SCD's. But we have used the CDC stage for handling SCD's. Pls folow this link.
viewtopic.php?t=87740
It will give you more information.
HTH.
--Rich
Last edited by richdhan on Thu Jun 24, 2004 1:03 am, edited 1 time in total.