DSXchange

Hi,

Can you please check the same parameter in DSParams file for that project...
If it is there you can remove it.
Hope this will help you out!

Thanks,

Thank you for your reply. Yes , double quote is a part of table name, table is like SCHEMA.AA_"SAMPLE". By describing table defination , I found that table name has quotes. I tried to select query from a tool , if I am passing table name without quote, the query is not running(invalid tabl...

Thanks for the reply.
But the table name in Oracle is "SAMPLE" so we cann't change the table name.We have to read data from that table.

Thank you once again.

Hi, I am trying to read data from an ORACLE table ,the table name is <SCHEMA_NAME>."<TABLE_NAME>" In the source oracle stage my sql query is: SELECT COL1,COL2 FROM REGION."SAMPLE" BUt the datastage is unable to read the data from the table having table name "SAMPLE" How...

Thanks !
It is working fine now

HI, We have input file as follows: XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXX...

It is better to read different columns in sequential file only...Then after that in the transfomer you can validate the records..

sequential file ---> FOrmat-->Field Defaults ---> Quote..

Thanks,

Hey! Thanks for your reply!
How to see CPU usage for a particular stage..

Hi,
Sorry I made a mistake in the post,
my question is: implementing a job logic using 3 Transformer back to back or 20 stage variable in single transformer (source ,target and datavolume are same ).

Thanks,

Hi, In a job design to achieve a particular transformation ,which approach will be better form performance tuning point of view ,using 3 TRansformer & 20 stage variable (source ,target and datavolume are same ). Which job will take lesser time.Its not an interview question. I am trying to do per...

I am developing a job to read from a XML file and loading the target table. I am unale to import metadata in XML o/p stage using XML Table defination option.It is giving error : Common Language Runtime Detected an invalid program Tthere is one post in the forum with same error msg ,but that doesn't ...

You can try with CFF stage or using Sequential File stage , In
Sequential File -->Format-->Record Level(right Click)---->Mainframe(COBOL)

Hope this will help out!

Goutam Lets make life simpler, I am doing nothing but reframing Ray's idealogy. Data pipelining only comes into picture when there is flow of data from one stage(operator) to another. It doesnt come into picture for a single stage. Regarding your second question. When you run a job on single. You c...

Hi, I am trying to load a sequential file from a XML stage. While running it is giving error: "XML_Input_0,0: Error: The name '{0}' is not a valid NCName. expression = '/:TestReportData/:TestData' Remaining tokens are: ('/') My job design is as: External Source Stage--> XML Stage---> Copy---> S...

I have noticed that when Column value is Decimal(2) then it is returning value '15.', which seems proper, but if i m converting it to Integer(2) ,it is returning '-717222919'.Is it the value in some other format. I couldnt understand "If your COBOL doesn't have a leading sign specificed then yo...