DSXchange

Can anybody tell me the correct difference between the Compile and Force compile. When there is Transformer stage in a job we need to do Force Compile sometimes. please explain me why Thnaks in Advance Usually when a job is in compiled state and there are no changes made to the stages , u try to re...

hi, As per the job design i would suggest you why do not you perform the join in the DataBase it will reduce the time and the overhead of the system. get the output of the join from the database into the required dataset in the DB2 stage do the following select a.clo1, a.col2 , b.col1,b.col3 from t...

sometime the monitor behave crazy. probably the link is showing fewer records because of the join stage. can you create another job with just the 2DB2 Stage ------------ 2Sort Stage ----------Sequential file Stage to check if the sort stage is still giving fewer records. Keshav, You are right. The ...

Yes
You can use convert function in transformer

Thanks,
Satish

If the string is length is more, say 50 then following can be used

Thanks,
Satish

Hi John,
I dont have duplicates and am not removing duplicates.
I checked the query results in DB2 client and there are no duplicates.

Hi Poornima, I believe you meant inline sorting in join stage. I used explicit sort stage because we had existing jobs. I just wanted to know why there is a difference in the record counts. Since an inline sort is equivalent to explicit sort, I thought this should work. Also I am using an inner join...

[quote="keshav0307"]have you explicitly partitioned and sorted again at the join stage. in the remove duplicate stage, the it must have already been partitioned and sorted.[/quote] Please check the job dump score. Look if there is a tsort added again. If it is added, it will hurt your perf...

[quote="getsatish_gk"]say how if i want to do something for columns at transformation stage?[/quote] You can perform the tranformations. But you will get a warning something like. "Droppping the <column> transformation as a prior column is already present". This happens because t...

[quote="getsatish_gk"]well this was logical :shock: ok. never view the data this way. then how to specify the columns for while loading at oracle stage?. as oracle i am using upsert write method to load into table any clue?[/quote] Try this. Just type in the metadata in the columns tab and...

Hi,
If RCP is enabled, you cannot view the data.

My understanding is
You are asking DS to propagate the columns at run time.
But you are trying to view the data at designt time.
So this is not possible.

Hi, We are using a federated join between 2 DB2 systems. and joining the output. Before joining we are using explicit sort stages to sort the data. Following is the job design (RCP is used) 1DB2 Stage ------------ 1Sort Stage ######################## ----- Join Stage --Dataset 2DB2 Stage -----------...