DSXchange

Thanks all. I solved my problem :D

Hai meena,

Good news. Just now, i spoke to my client. I explained everything.

finally they accepted our job. Thanks for everyone :D

Regards,

prabu

yes, I did . Using the 2nd Aggregator , i maximize the value. Then i put sorting stage and sort stage connected to Hashfile. Ok , data is coming good. But now, we need to find the max data through 2nd Aggregator. That means 2nd Aggregator will connect to Hash file. After the 2nd Aggregator dont put ...

Hi, We have developed the job. like this OCI(Source)-->HASHFILE(Refere)-->TRAN-->SEQFILE-->AGR(SUM)-- >AGR(MAX)--->SORT-->TRANS-->HASH We lookup the data in to transformer and these records are loaded into a Sequence file. After that using the Aggregator, we found the Sum value and once again we put...

I removed that corresponding hardcoded value and i hardcoded value

once again for that column. And i check the column one by one and run

the job. Now, the job is run successfully. Thanks all :D

Hi All, I have one problem. I hardcoded Some value in to one column. When i execute the job, that corresponding column show that hardcoded value for only one row but Other row not show that hardcoded value. I think Some Logical Error. Can anyone help me . How can i solve that? EX: AGG_GRID_OUTPUT : ...

Thanks all. Now, my job is run successfully.

Your link did not show anything. It has show only usernamd and

password. can u give me the correct link.

I sorted the data , using sort stage. Some data has come in to the Error Target Stage. But it has not come all duplicate records. That data has come like that. ACCT CODE --------------- DEPT CODE 2345 ----------------- 450000 3456 ---------------- 450000 2345 --------------- 436789 I need output lik...

Ur code is working fine. But it is did not take any duplicate Records. It has come some rows. Once again i explain my condition. Input Data : ( Don't Considered ------) COLUMN1 ------------------- COLUMN 2 RAJ ------------------- INTEL KAMAL ------------------- ORACLE PRABU -------------------- VELT...

Ur Code is working fine. it has come some data. But that is not duplicate records. Once again I explain my condition once again. Column1 ---------------------------- Column 2 Input Data: Dont considered -----. Suresh ---- Intel Raj ---- Oracle Suresh ---- Intel Kamal ---- Veltech Raj ----- Oracle Ac...

Hai lovejo, I also tried what u said. But still it is not work. what i did there. (Acc Code and Dept Code) Stage Variable: Prev Row--------------------> Acc Code Curr Row---------------------> Acc Code : Dept Code In Constraints: Good Records: CurrRow<> PrevRow Error Records: CurrRow = PrevRow I tri...

i tried ur ida. But it is not work. I tried Like that. PrevRow -----------------> AccCode CurrRow ------------------> DeptCode Then Set in constraints Error Records: CurrRow=PrevRow Good Records: CurrRec<>PrevRec In Error Records Link did not show any records. It is showing only Zero Records. Can u ...

Ok, Now, I am using the Sort Stage I sort the data. Then How can i write

query in Transformer. I know that , create Stage Variable. My

Comparing column in Acct Code, DeptCode. Can u help me the query.

Ok, Now, I am using the Sort Stage I sort the data. Then How can i write

query in Transformer. I know that , create Stage Variable. My

Comparing column in Acct Code, DeptCode. Can u help me the query.