DSXchange

I am not able to access any projects.

I have installed server in Windows XP.Is that a problem?

I did not edit the UV.ACCOUNT table.

Hi, I recently installed datastage 7.5 server and client in my Dektop. My OS is windows XP. After installation , when i am trying to connect to a Project(sampleproj) through the Administrator getting the following error message. "Failed to attach to 'sampleproj'. Project 'sampleproj' expiry dat...

Try to use $APT_STRING_PADCHAR=0x20

Add a join stage and join the two ouputs instead of keeping the files.Make the dummy field as the key
Then you will get the o/p as

Key col1 col2
1 header trailor

Hope it will help you

Hi, I solved the issue by adding some dummy data when there is no rows in the history table. Now i am getting the output ,when there is a change in the existing records(update) in the history table and if any new records(insert) are coming from the master table. Is there any way to find out the reco...

Hi, I am trying to implement SCD2 using the SCD stage. My source tables are like 1.table_XX 2.table_XX_History. I am using the history table(table_XX) as the reference I am trying to find out the modified/New records.But for the first run when the history table is empty ,i am getting the warnings li...

Hi all, I am very new to data stage.I got a compilation error when i was desining a small job on transformer.I am using datastage 8.0 and visual studio 2008. I have set LIB and INCLUDE environment variable in my wnidows environment.could any body help me in this issue What is the ERROR? :evil:

Create a lookup with the target database and insert the records only if the key values are not present in the target.Pull out the reject link for this.

Use a transformer stage with some stage variables like Stagevarnew Stagevarprev Map the Stagevarnew to the Stagevarprev.Assign the key value(Here first column) to the Stagevarnew.Compare both stage variables for the group by Process.add/find out the difference for the rows having same key values. Mi...

Read the whole file in one field without giving any delimitter.
Then use the change function to convert the two consecutive space into a single space.Then you can split the records using a Coulmn import stage giving space as delimitter

Let me know the results !!

Try by changing the Execution mode as "sequential" in transformer stage.

In transformer stage :- STAGE ---->Advanced----->Execution mode

Change that to Sequential.

Please let me know the results.

Define two variables

StgVar1=stgVar2

StgVar2=Stgva2+1------->Initial Value=1


Try atleast for 5 minutes.
Then reply.

Define two variables

StgVar1=stgVar2

StgVar2=Stgva2+1------->Initial Value=1


Try atleast for 5 minutes.
Then reply.

Generate a new keycolum for each file .You can make use of a transformer for that.Declare a stage variable.Make its initial value as 1.Then increase its value by one for each row.so that it's value will come as 1 2 3.... Make the same logic for both the files.Then your inputs will become Input1 Key ...