Hi All.
I have a question regarding Standarize stage.
I have a job using a Sequential File as an input which then goes to a Standardize stage and outputs to another Sequential file. I have established the needed rule sets for selected columns and created the needed mappings as well. I used a Sequential file as an output to enable me to view the standardize data using any text editor. Output files in QualityStage 7.5 can be viewed using any editor and this is useful for me when doing data analysis.
The job runs with "no errors", however, zero(0) records were exported to the sequential file and all of the records were rejected.
I then changed the output file from a Sequential File to a Data Set. The job ran successfully and I can view the standardized data from the Data Browser.
My questions are:
1) is there a setting that I'm missing that prevents the standardize data to output to a sequential file?
2) Is there a way to output the data to a text file which I can view from any editor?
Thanks for the help!
Standardize data output
Re: Standardize data output
hi ,
When you writing output to the sequential file you have to set default null value. if you dont configure this you cant see any records in output file. Eventhough you can see status as success.
it will apply to all jobs in datastage/qualitystage...
regards
When you writing output to the sequential file you have to set default null value. if you dont configure this you cant see any records in output file. Eventhough you can see status as success.
it will apply to all jobs in datastage/qualitystage...
regards
ijkmnop wrote:Hi All.
I have a question regarding Standarize stage.
I have a job using a Sequential File as an input which then goes to a Standardize stage and outputs to another Sequential file. I have established the needed rule sets for selected columns and created the needed mappings as well. I used a Sequential file as an output to enable me to view the standardize data using any text editor. Output files in QualityStage 7.5 can be viewed using any editor and this is useful for me when doing data analysis.
The job runs with "no errors", however, zero(0) records were exported to the sequential file and all of the records were rejected.
I then changed the output file from a Sequential File to a Data Set. The job ran successfully and I can view the standardized data from the Data Browser.
My questions are:
1) is there a setting that I'm missing that prevents the standardize data to output to a sequential file?
2) Is there a way to output the data to a text file which I can view from any editor?
Thanks for the help!
vairamuthu
Re: Standardize data output
That worked. Thanks vairus!!
vairus wrote:hi ,
When you writing output to the sequential file you have to set default null value. if you dont configure this you cant see any records in output file. Eventhough you can see status as success.
it will apply to all jobs in datastage/qualitystage...
regards
ijkmnop wrote:Hi All.
I have a question regarding Standarize stage.
I have a job using a Sequential File as an input which then goes to a Standardize stage and outputs to another Sequential file. I have established the needed rule sets for selected columns and created the needed mappings as well. I used a Sequential file as an output to enable me to view the standardize data using any text editor. Output files in QualityStage 7.5 can be viewed using any editor and this is useful for me when doing data analysis.
The job runs with "no errors", however, zero(0) records were exported to the sequential file and all of the records were rejected.
I then changed the output file from a Sequential File to a Data Set. The job ran successfully and I can view the standardized data from the Data Browser.
My questions are:
1) is there a setting that I'm missing that prevents the standardize data to output to a sequential file?
2) Is there a way to output the data to a text file which I can view from any editor?
Thanks for the help!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please get more information from them, including an eCase number. If they know it's a bug, then there's an eCase number, because the bug will have been reported.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.