DB2 Enterprise Stage with Transformer Stage
Moderators: chulett, rschirm, roy
DB2 Enterprise Stage with Transformer Stage
Hi all,
We require to bifurgate data into 4 datasets based on a condition from a table.For which we tried the following method.
Job Design:
DB2 Stage-->Transformer Stage-->Dataset
But while compiling the job it is giving the following error message :
"A configuration file(APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage."
Please let me know if there is any resolution for this error or do we need to modify the design like below
Job1:
DB2 Stage -->Dataset
Job2:
Dataset-->TRansformer-->Dataset1,Dataset2,Dataset3,Dataset4
Thanks in advance
We require to bifurgate data into 4 datasets based on a condition from a table.For which we tried the following method.
Job Design:
DB2 Stage-->Transformer Stage-->Dataset
But while compiling the job it is giving the following error message :
"A configuration file(APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage."
Please let me know if there is any resolution for this error or do we need to modify the design like below
Job1:
DB2 Stage -->Dataset
Job2:
Dataset-->TRansformer-->Dataset1,Dataset2,Dataset3,Dataset4
Thanks in advance
sanjeev kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please check what is the default value given to that Enviroment Variable $APT_CONFIG_FILE in that project using Administrator.sanjumsm wrote:But while compiling the job it is giving the following error message :
"A configuration file(APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage."
Please let me know if there is any resolution for this error or do we need to modify the design like below
If the default value is not given for $APT_CONFIG_VALUE and the default config file(config.apt) is not found in the Working directory and in $APT_ORCHHOME/etc, DataStage will throw an error message like below if we attempt to even compile the Parallel Job having Transformer Stage.
Error message wrote:A configuration file(APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any reason what this error message conveys at first.(why there must be a need for parallel Engine to have look at Config file on compiling a Parallel Job having Transformer Stage)ag_ram wrote:If the default value is not given for $APT_CONFIG_VALUE and the default config file(config.apt) is not found in the Working directory and in $APT_ORCHHOME/etc, DataStage will throw an error message like below if we attempt to even compile the Parallel Job having Transformer Stage.
Error message wrote:A configuration file(APT_CONFIG_FILE) must be set up to compile a Parallel transformer stage
Note: If we dont have config file in the mentioned paths apprantly and compile a parallel Job which does not have a Transformer Stage inside, the Job gets compiled well.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The "bi" in "bifurcate" means "two".ag_ram wrote:Could you please let me stay in the meaning of your words here?ray.wurlod wrote:<pedantic>
You can't bifurcate into four.
</pedantic>
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.
ray.wurlod - Is this you wanted to convey? please confirm.mahadev.v wrote:Bifurcate means cutting into halves. That means two parts. and so bifurcate into 4 makes no sense and the word is used out of context. Ray is pointing it out. Nothing related to the actual topic i guess.
I dont think that he might mean this because that post is highly relevant to the topic.
-
- 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:
Let me render a high respect to you by having given a humorous gesture.ray.wurlod wrote:You are entitled to your opinion.
I, on the other hand, rejoice in having a sense of humour.
And would like to ask you a question - Would be able to provide a valid reason for my statements being consiered as superfluous since i did indulge myself into an experiment?