DSXchange

Hi , I am having 2 Tables Product and Category. My requirement is I have to capture the records those are present in Product table and not found in Category table and Vice versa in a single job. The common key is product _id. PRODUCT CATEGORY *********** *************** PROD ID CATG_ID CATG_ID CATG_...

Hi,

Without knowing the Max Count it is not possible to define the output columns..

If you are thinking that the max values you can receive for the Field2 as 5 then define 5 output columns in the column import stage and propagate the columns to the pivot stage..

Cheers
Siva

Hi , Use the Column Import Stage in that Import Input Column=Field2 and in the Output define the columns as Filed3 and Filed4 and in the Output Format Tab final delimeter as 'none' and filed defalts as 'Comma' after that use the pivot stage. In this method no need to use the Transformer. Flat File -...

Hi ray, Actually the job is showing 2 records on the XML Outputstage link. My question is in the Options tab of the XML Output stage I have given the path for the Output file as:/datastage/tmp/customer.xml.But no file is created in that Directory... So How can I view the data in the XML file? Regard...

Hi, I have created the XSD file as follows. </xsd:schema<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:element name="Employee" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element name="ID="xsd:string> <x...

Hi , I am having the Sequential file data as follows. ID,Name,Location,Phone 1,kumar,hyd,123 1,kumar,ban,456 1,kumar,tpt,789 2,siva,kud,111 2,siva,chit,223 I am getting the O/p in the Sequential file as follows. Col1,col2,col3,col4,col5,col6,col7,col8 1,kumar,hyd,ban,tpt,123,456,789 2,siva,kud,,chit...

Hi , Basically I need the reject files based on my job runs.Suppose if my job runs 5 times in a day then I have to execute my job 5 times so 5 Rejecte files are to be created with/ithout rejected records. The reject file name cinatains "RejectFile_Date_<JobrunNumber>" Here the <Jobrunnumbe...

Hi , One moer thing for each run I have to create a Reject file.If i set the Job in between Start and end loop I have to give the Values for From Step and To properties of the Start Loop Stage. I have given 1,1,1 it executes the job one time and the counter value is also 1. If I executes the Sequenc...

Hi , While using the Start and End Loop we are getting the Counter Values. As per the requirement I have to reset the Counter Value as Zero(0) for every day run. How Can I achieve this in Data Stage? If this we have to achieve by using Unix script then what are the steps we have to follow? Please he...

Sainath, In the fisrt post onlly I mentioned I am having the problem to store the values for the Environment Variable. What ever the responses you have given is stating that you are not at all read the complete problem. If i give the solutions to others then I can not give one line answers. based on...

Hi ,

For Individual Job you have give as "Your Method".In my method I am unable to store the values in the Environmental variable that is my question?

If you know the answer then please revert me back...

Thanks
Siva

Hi ,

If it is the individual job then what is the solution?

If it is running from the sequence then what is the solution?

Thanks.
Siva

Hi , I am having the PX job design as follows. Oracle Stage--->LkpStage-->Oracle Stage. When the Look up is filed I have to create the Reject file with Data and the Number of the Job Run.The reject file (Sequential File Stage) is having the file name as: CutomerReject_`date +%d_%m_%Y_$MYVAL` Here th...

Hi , I am not using any meta data (Columns) in the entire job.While writing in to the Sequential file it is giving the Warnings as Null handling is not handling.For that I set the property in the Sequential file stage in the format tab Null Field value=0. But still I am unable to get the data in the...

Hi ,

Check the metadata data types and check the null handling of the columns.