DSXchange

Thanks for the Info. Actually we have 8.5 in development and planning for 8.5 in test and prod eventually. But as we dont have test and prod in 8.5 and 8.5 is incompatible to 8.0 we are designing in 8.0 dev. I will try to design it in 8.5 once we get test and prod, can you please let me know what ch...

are there any stages with the same properties in server job?

how can the links do commit or roll back ?

I never designed a server job......when do we use the server jobs?

To do the same design in a server job I cannot see some stages in server palette such as lookup,funnel etc


I have around 10 links coming from 10 transformers and then Funnel stage to WISD output.

Based on this where do I need to use the output links?

please suggest

It is a batch job which is invoked as a service from ISD and the job as WISD input and WISD output stages. This is 8.0.1 release and the job is a parallel job. As this is always on service it runs 24*7 i.e always. The request is around 6 fields and this is validated with some tables and then inserte...

I have a service oriented job which has around 30 to 40 odbc PX connectors. I use most of the connectors to insert or update, When the service is called and a request is sent sometimes the service aborts which ends with inserting or updating only some of the tables, my requirement is if the service ...

I handled the nulls,the problem was In 8.5 there is nothing to do for handling nulls but in 8.0.1 I had to mark them as some value.


Issue resolved.


Thank you ALL

Field 'state_cd2' from input dataset '0' is NULL. Record dropped

I see this kind of warnings more in the director.

Actually we have values for the provided fields but why does it show NULL.

As it is null it drops.



any suggestions please

$APT_NO_JOBMON which is false.

Is that the difference?

Actually in the Development clients I see the job monitor but in Test I cannot see the job monitoring.



Thanks

I searched the forum and found an environmental variable to be false. I see in my project its already false. Earlier I could see all these after the upgrade from 8.1 to 8.5 I cannot see anything when the job is running in the designer.(rows,colors) Do I need to change anything in the server? Thanks

Hello,

A simple doubt about the status of jobs.

When we run the jobs in the designer, I can see blue first and then red if aborts and green if finished.

Now I cannot see anything in the designer when the job finishes or aborts not even the blue color.

help me with any settings?

I have to design a job in which the source contains 1 million of addresses and the target should be the validated addresses from the source. For this validation source----->cass----->standardization----->target or Source------>standardization--------->cass------->target please let me know which shou...

So, just play around with the blocking and matching criteria. Yes, I standardized the data Using USNAME---->firstname,lastname Using USAREA---->city,state,zip UsingUSADDR----->addr1,addr2,addr3 After standardizing I used match frequency for the frequency data for source and reference. But what happe...

The blocking columns in the three passes were 1.NYSIISfirstname,last_name,zip 2.License_num,License_state,gender 3.last_name,gender,first_name The matching commands contain the other columns firstname,middlename,street_no,first_init,gender,last_name this is reference match and has onetomany multiple...

Earlier the matched records were only 20,000 but after I changed the blocking columns and the matching commands the matched records increased to 89,000.

But these matched records are not equal to the matched records in the passes.

Why does this happen?

Source has 3 million records and the reference has 0.2 million records. The source and reference along with their frequency's have been matched using reference match with a match specification which has 3 passes. The outputs I used for the match reference are matched and clerical. After I run the jo...