DSXchange

dsjob -file dslogininfo.txt -run -mode NORMAL XXX YYYY So, dslogininfo.txt is in the same location as dsjob? If not, provide a location for it. Mike dsloginfo.txt is located on a seperate path, and i m providing the path like this... dsjob -file c:\temp\dslogininfo.txt -run -mode NORMAL XXX YYYY

But in Programmer's guide it specified: for dsjob command only: -file filename NONE enginename domainname specifies the domain for which the file contains logon details. For dsjob, you can set NONE to log on to the engine rather than the domain. enginename specifies the engine for which the file con...

I am passing the servername, userid,password through a file to the dsjob command.
But i am getting error saying "Failed to located Information for Server"

Project Name = XXX
DataStage Job Name = YYYY

dsjob -file dslogininfo.txt -run -mode NORMAL XXX YYYY

Login Info is in the file name = dslogininfo.txt
servername,userid,password
cnaetl101,ds1245,htu098yg

I am converting float(126) to varchar(255) using transformer function DFloatToStringNoExp(<inputcolumn>,10) .Source is oracle and target is sequential file. Source column data is 80721804.076 but in target i am getting the value 80721808. I don't want to use cast at oracle side.Can any one help me t...

Hi Erine, Thanks for your reply; Then, even before your reply, I resolved, i did the same thing which you mentioned in your reply :-) In XML for each of "independently" repeating nodes, each one must have its own link. <purchase order> <items> <address> So item will have product info.. <it...

Hi Ernie, As you mentioned, I kept only 1 XML input stage and tried to pull the XML chunk into a flat file; I am getting; Now if i replace the flat file and put another XML input stage to further falttern the XML , it is throwing error: XML_Input_185: XML input document parsing failed. Reason: Xalan...

I am getting Error: The column of the output link is relative. Error occurred in call to ORPHCallActivePluginInitialize(). The runLocally() of the operator failed. Here is my part of XML: - <ns9:ProgressiveQuoteChoice> - <ns9:ProgressiveAutomobileQuote> <ns9:sourceOfBusiness>Progressive.com</ns9:sou...

Hi Ernie, We are generating reports using jobs. If we use extract job and then create a report for 'where does data come from' then we are able to see extended data sources but if we use any other job (which uses Database as reference) then we are unable to see extended data sources in the report. A...

Hi everyone, We are using automated services for our data lineage project and recently we imported all the extended data sources and completed extension mappings as well. Now when we generate report for 'where does data come from', we are unable to see the extended data sources for either those jobs...

So u meant to say i can use HTML coding in datastage..? Sorry i didnt understand can you please shed some light on this.....

Hello, I was trying to create a .html file in datastage. Structure of the file contains two columns. When i generate the file in .html and move the file from Unix to windows i was not able to get the output in a tabular form. Its coming as a line. Please can anybody help me on this. Thanks in advanc...

Hi, I understand as part of the ETL Architecture design we can have an Audit Check & Balance layer. The idea being to be able to reconcile between source record counts against the rejects + loaded records. Gathering Statistics at a link level can also be done via a script that pulls this data fr...

hi everyone, Recently we created extended data sources and extention mappings for our project. Now when we generate a report using extended data source for 'where does data go to' we are able to see a proper report which includes extended data sources, extention mappings, jobs and tables. But when w...

Hi, We have an insert statement and we are using the Write Method as Upsert in Oracle Enterprise Stage. My Question is - What is the difference between using the upsert mode - "User Defined Update Only" mode and writing the Insert statement here against using the "User Defined Update ...