Connectivity

[vbeeram]

Hi,

How to make connectivity for Peoplesoft EPM from Datastage

thanks
vbeeram

[kcbland]

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)

[denzilsyb]

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:

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

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.

[vbeeram]

"Thanks I got it now"

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:

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

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.

[richdhan]

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

[elavenil]

Hi,

First, you decide how you are going to handle this SCD in your DW. There are few stages available in PX to do the comparison. We use ChangeCapture stage to find out delta and we use type 1 to handle SCD in the project.

Saravanan