DSXchange

Here are my Current dataSet (before) and Previous Dataset (After). What is the expected output code in DataSatage "" Blank String Field 1 and Field 2 are Change Values. Key =A and Key =B are two records for which I want to know the expected output from the CDC stage. Input filed-----------...

One Q which is going back to the basics would be does a key definition on a dataset enforce uniqueness? I need to reuse a dataset multiple times. The keys defined while writhing the dataset are Key1, key2 & key3, When the dataset is read the keys defined are Key1,Key2 and sometimes key1, k2y2, k...

It doesn't really matter where it happens, there's just no way to shoehorn seven characters into a Char(5) column. I do not want to shoehorn seven characters into a char(5) column datastage does that by truncating the last two digits. I am trying to detect the records that have the seven characters...

I have data going in form a Varchar field to a char field. varchar 255 (from file) to char 5 (db2). Input string string 1234567(varchar255) is loaded to db2 table as 12345 (char5) The last two digits in the string are truncated without a warning or a database error, WITHOUT WRITING ANY CODE is it po...

Would like to avoid using the IsValid function and another reject link. Will need to use IsValid on many tables and fields. There willl be very little to no impact on performance as there will be very few records go down the db2 reject link.

I am using a DB2 connector to load a table. The table has a decimal field. When I load the decimal with a character it loads a 0.0 in that field. I want it to throw a database error so that I can trap this on the DB2 connector reject link. Is there a variable or setting that I can enable to make thi...

Did the install for datastage on windows. Cannot get inside the webconsole with the dsadm password. Is there a default user name password that can log me into the web console

error: invalid user name password.

I need to convert a character string with any special characters in them.

Something like the convert function but want to use a ascii range to schan the characters and remove them.

I need to scan all special characters (Hex code - 0 to 1F) and remove them. Can I do this with a single function.

If what you currently have is working, it may not really be worth the effort to clean out the cobwebs... unless they are really bad and make maintaining/understanding them overly difficult. Still working on one prototype. Sp I guess time and resources available will decide the option we want to tak...

Thanks for the idea of creating a sub sequencer. need to see how much time this will take we have 70+ sequencers were this change needs to get into.

Here is how the sequencer looks. S1Extract-->S1ToOracleALL1 S2Extract-->S2ToOracleALL1 S3Extract-->S3ToOracleALL1 S4Extract-->S4ToOracleALL 1Harmonize &SurviveLoad Staging S5Extract-->S5ToOracleALL1 S6Extract-->S6ToOracleALL1 S7Extract-->S7ToOracleALL1 S*Extract Job --- Extracts from So...

I have need where we need to ignore GUI code on what is on the Job designer. We can do this in the sequencer that calls the job using a nested condition and sequencer to meet needs. With the nested condition and sequencer[set to any or all] the sequencer looks like a messy cobweb. I need to do have ...

I have used datastage and info server to connect to ERP systems in the past. I now need to connect to a Navision ERP system. I am not sure if there are special connection or we need to go through any application layer before we can connect to Navision. Was wondering if anyone in the fourm might have...

Yes ... You can use the ABAP Extract pack sucessfully on a unicode system. You need to import the meta data from the unicode system and make syre you generate the ABAP on the unicode system. There are differences in the generated ABAP on a unicode and non unicode system. On the colums Tab the displa...

We currently have the Enterprise Edition and will upgrade to Hawk (Integration Server)...Is the SOA and TX Edition run on a different server (different from the Integration server)...Is comparing TX & SOA with Hawk like comparing apples and oranges... Would TX/SOA have the same performance level...