Query About join stage in PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Query About join stage in PX
Hi All,
I have a job, where calendar_dt from source file should match the calendar_dt from a file, which is created by querying a table.
i just wanted to know if the join condition fails, does the job fails too?
in my case, the job is not failing and clearly data is getting loaded as it should be.
I have included the above job in sequence, as the above job doesn't fail the sequence also shows success.
please let me know about this.
thanks in advance,
Deepak
I have a job, where calendar_dt from source file should match the calendar_dt from a file, which is created by querying a table.
i just wanted to know if the join condition fails, does the job fails too?
in my case, the job is not failing and clearly data is getting loaded as it should be.
I have included the above job in sequence, as the above job doesn't fail the sequence also shows success.
please let me know about this.
thanks in advance,
Deepak
Hi Deepak,
If the data is loaded as it should be why abort the job?
In the join stage you cannot abort a job. Use the lookup stage and set the lookup fail property to abort.
The transformer allows you to abort the job using the Abort after rows property.
If the job does not fail why should the sequence fail? The sequence aborts only if any of the job aborts and the trigger condition is set appropriately to abort the sequence.
--Rich
If the data is loaded as it should be why abort the job?
In the join stage you cannot abort a job. Use the lookup stage and set the lookup fail property to abort.
The transformer allows you to abort the job using the Abort after rows property.
If the job does not fail why should the sequence fail? The sequence aborts only if any of the job aborts and the trigger condition is set appropriately to abort the sequence.
--Rich
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am
Hi Rich,
Thanks for your suggestion....
now the job is aborting using lookup stage if lookup fails.
now i have to reject these records or file which fails lookup.
am getting error message like this.
"Reject link is not allowed unless an input reference link failure property is set to reject"
please give ur inputs
thanks,
deepak
Thanks for your suggestion....
now the job is aborting using lookup stage if lookup fails.
now i have to reject these records or file which fails lookup.
am getting error message like this.
"Reject link is not allowed unless an input reference link failure property is set to reject"
please give ur inputs
thanks,
deepak
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi,
As per my understanding,in the lookup stage constraints there are two options:
Condition Not Met and Lookup Faliure.
If you have given some condition and if your requirement states that if the condition you have mention
is not satified then you want to fail the job, in that case put Fail in that tab.
Now in Lookup Failure according to your requiremnt if you want to fail the job , if the lookup fails ,
then set it to Fail.
If you have only one link and for both the option you have entered it as Fail, then your job will not
comiple. You ca not achieve both..
As per my understanding,in the lookup stage constraints there are two options:
Condition Not Met and Lookup Faliure.
If you have given some condition and if your requirement states that if the condition you have mention
is not satified then you want to fail the job, in that case put Fail in that tab.
Now in Lookup Failure according to your requiremnt if you want to fail the job , if the lookup fails ,
then set it to Fail.
If you have only one link and for both the option you have entered it as Fail, then your job will not
comiple. You ca not achieve both..
Hi Deepak,
Error: "Reject link is not allowed unless an input reference link failure property is set to reject" .Means you did not specified the lookup stage condition correctly.Go to the lookupstage and check the condition.There you have to give it as lookupfailure reject.And take some sequential file,link it to lookup stage and send those rejected recods to the sequential file stage.And also check the data.
Cheers,
ds_sai
Error: "Reject link is not allowed unless an input reference link failure property is set to reject" .Means you did not specified the lookup stage condition correctly.Go to the lookupstage and check the condition.There you have to give it as lookupfailure reject.And take some sequential file,link it to lookup stage and send those rejected recods to the sequential file stage.And also check the data.
Cheers,
ds_sai
Hi Deepak,
Your lookup stage should have 4 links altogether.
1. One input link 2. One reference link 3. One output link and 4. One reject link if you set the lookup failure condition to Reject.
I think you have 2 reference links. Just click on the specific reject link and right click and change it to reject link.
HTH
--Rich
Your lookup stage should have 4 links altogether.
1. One input link 2. One reference link 3. One output link and 4. One reject link if you set the lookup failure condition to Reject.
I think you have 2 reference links. Just click on the specific reject link and right click and change it to reject link.
HTH
--Rich
-
- Participant
- Posts: 47
- Joined: Wed Apr 18, 2007 4:49 am