DSXchange

Hi Carlson

Yes, I was referring to the Change Capture stage.

The Change Capture stage will work perfectly for your situation. You have to define the fields in the change values section of the CDC stage and change_code additional column will detect the update.

HTH
Rich

Hi Kim, It is a good script but I have some clarifications. ################################################################################ # Runnable Job Status (do nothing) # 1 "Finished" # 2 "Finished (see log)" # 9 "Has been reset" # 11 "Validated OK" # 1...

Hi,

Do a search on "handle_null" in this forum. A lot of examples have been discussed before.

HTH
Rich

Hi Roy,

Are you using Oracle as DB? With oracle the columns that are defined as Number are by default getting imported as Decimal(38,10). We use the DecimalToDecimal function avialable in Transformer to reduce the size as well as the precision.

HTH
Rich

Hi Sathish,

All these options are enabled for a server job but not for parallel job. What do you mean by limited number of rows? Do you want to run for the first 50 rows or you want to limit the number of rows based on a condition. In either case you have to use the Transformer constraint.

HTH
Rich

Hi Memrinal, Colum Method = Schema File is used by sequential file stage/file set stage. It is basically used when you dont want to give the metadata directly in the stage but rather use the schema file for getting the metadata information. A sample schema file looks like this schema record ( column...

Hi Madhav,

Use the CDC stage. It gives an additional column change_code which is used to identify insert, update, delete or exact copy. Pass the data from CDC to a transformer and using stage variables you can find the count of inserts, updates and total count.

HTH
Rich

Hi lshort, Look into the CDC stage. The documentation in parjdev.pdf gives additional information on CDC stage. It is used to identify new inserts, updates as well as deletes. You can finish it in one job. The CDC stage requires 2 inputs. Use the flat file as one input and the DBMS data as the other...

Hi Vincent, The sparse lookup is different from the normal lookup. The sparse lookup sends individual SQL statement for every incoming row. It is useful when you want to get the next sequence number from oracle or DB2 sequence. Since it is sending a SQL statement for every incoming row it should not...

Hi NewPXUser,

Did you try the solution I had provided.

Rich

Hi Harithay,

If you know stage variables can do it and dont know how to write them then do a search on stage variables in the Server forum. There are a lot of examples that have been discussed.

Rich

Hi NewPXUser, If you want to use a schema file for a sequential file then you create a dummy job which loads a fileset with the following column configuration. Open the fileset and get the schema structure. Use the schema structure for the sequential file. Hope this resolves all your issues. Keep us...

Hi Bird,

This has been discussed before. Do a search on handle_null. Modify stage uses orchestrate functions. Use handle_null in the modify stage specification.

Rich

Hi, From your post I believe you are using a sort stage followed by a join stage. I dont think this is necessary. The sorting can be defined in the join stage itself. In the join stage are you using hash partitioning? In the hash partitioning have you set the perform sort option? If you are using jo...

Hi,

Look into this post.

Yes, regardless of what type of Oracle table is accessed, the select privilege on the above system tables should be granted in order for a parallel job using Oracle Enterprise stage to execute successfully.

HTH
Rich