DSXchange

No Option as stated but why do you want to hide the links, ant specific reason.

The product itself is used to explain how the data is flowing from the SOURCE to TARGET.

Regards
mahesh

Hi, As stated could you pls tell about Data Stage version 9?? :?: About working on XML Stage: If you need to load the Flat file data into the XML format, you need to have the meta data of the XML file u want to create i.e., the XSD i.e XML Schema file definition using which you could create the XML ...

Hi, I did experience the same issue in my previous project, as the Guru suggested you can have two Sequential files, one for for Inserts and One for Updates and then using the Oracle Bulk Stage you could Insert the data and then in the next you could do your Updates. As suggested "Leave your jo...

Hi All, Could you anybody share there experiences about using SAP R/3 Load IDoc Stage. If possible please send me the possiblities of tuning for faster loading of data into the SAP system using SAP R/3 IDoc Stage. Many thanks in advance. Wishing you'll an advance New Year Wishes and belated Christma...

Hi Kumar/ All, As stated by you, - I tried directly Loading the Target data into SAP R/3 Load IDoc Stage and nothing was happening for a long time (Nearly 3 hrs , hangs up with out giving any erro message or warnings) though most of the transformations and Business rules applied was done much quicke...

Hi All, There are a couple of Source Systems , after applying Business rules to the data and necessary transformations done the data is loaded into the SAP system which is my Target using SAP IDoc Load stage . The process is fast until the Transformations where we get the necessary O/P data that nee...

Hi. Coul you check the time stamp data which your tring enter, Is it in the following format YYYY-MM-DD HH:MM:SS or do you have microseconds attached to the same, I mean concatenated to the same. Please check teh database and what ckind of Timestamp is allowed for better handleing. Hope this helps. ...

Hi, Could you please check the Type and Setting of the Nullable colums, You might have set it as "YES" for the Nullable columns in the COLUMNS tab and so data when inserting is giving the following issue: nsartable..Transformer_1.DSLink17: DSD.BCIPut call to SQLExecute failed. [DataStage][...

Hi, The VOC file are very important files for DS, in this case if you can ask your UNIX administartor if they do a back up of all what is available on the UNIX Server and ask them to give you a dump of it and then you can reinitialize the DS Project and it should be fine. Hope the above helps. Thank...

Hi,

In the Sequential File stage in the Output, Goto Properties -> Columns and In columsn you have "Incomplete Columns" , Its a drop down list and select the option "Replace" and run the Job.

Hope this helps.

Thanks & Regards
Mahesh

Just to add on you could use the XML Metadata importer, Which would have been insatlled in the DS v7.0, In the DS Designer Tools -> Customize -> XML MetaData Importer Normally would be available in the following directory: Program Files\Ascential\DataStage\XMLMDImporter.exe Include the same and you ...

Where do you have the Database / Analysis Server ? , Please try to Restart the Server and should be resolved.

Hope thsi helps.

Thanks & Regards
Mahesh

As you problem is that there a some Null values which come out as ? , in order to avoid this you could also use a srNVL(COLUMN_NAME," ") which actually puts in an empty value.

Hope this helps.

As Sainath pointed out this will put in a Empty Value.

Regards
Mahesh

I guess you must have the XML Input/output stage installed on your system, Once you have the file Use the XML Metadata Importer and Import the Table Definition for the file and then you could use the XML Output stage to retive the values by passing the appropriate parameters. Hope this helps. Thanks...

Could you please check by passing srNVL(columnname,"") in which ever column you have Null values.

Hope this helps.

Thanks & Regards
Mahesh