DSXchange

Correct me if Im wrong ! Merge :- I see there are four fileds in one file and 5 fields in other file . and output required is 5 fields o/p. ClaimNo1|Version1|?||XX|xxxxxxx ClaimNo1|Version1|i temno1 |XX|xxxxxxx ClaimNo2|Version1|?||XX|xxxxxxx ClaimNo2|Version1|i temno1 |XX|xxxxxxx Q 1:- can we subis...

U can do with concatinate and substring !

Yea ! Sounds grt8..

good and bad are two different input file ! 1- I think we need to merge both the good and bad . 2- then sort the good and bad based on some commom key ! 3- assign some surrogate key to track the records . < my question is i have to caputer the above and below record of bad> 4- collect the records of...

explanation :- rec :- 1good 2good 3bad 4good 5bad 6good these are the records comming from inputs file... i want to capute the bad record as well as before and after records of bad i.e good rec. like :- 3bad ,2good,4good as output 5bad,4good,6good. ideas will be appricated thanks in adv !

can we convert string to decimal via !

Thanks -

this what Im looking for !-
now we can apply a logic !

if file is in use
then
abort job2
else
run job2.

Ultramundane wrote:The unix command fuser can be used to determine whether a file is in use or not.

writein subroutine the same logic what ever you are using in transformer . It will improve the perfromance.

Thanks for the reply! My question is 1- lkp A is using job1 as lookup 2- Job 2 writting the same file - lkp A. -- scenario 1:- Is there any way we can find the wheather JOb 1 is reading lkp-A.so that we can stop writting until it reading is finsihed and we can trigger the job2 to write the same fil...

sorted in descending order + then joined ryt check the join component sort options .it should work... please let me know .. What I did: I did a Right outer join on two input files using join stage in to a dataset. I partitioned both inputs by "Hash" on key using inlink partition. Observati...

what ever the ray told ! that i know ..
I am asking if you get same problem how do you deal.









Problem to problem is not solution !

ray.wurlod wrote:Standard medical advice: if it hurts, don't do it. ...

what else you need ! I have explained the problem ?
Please let me , I will try my best..
we approch the forum hoping of some solutions .

situation where one graph is rebuilding a lookup file, while another graph is reading from it. The graph that is reading from the lookup gets "killed" by the graph that replaces the lookup.

thanks in Adv

situation where one graph is rebuilding a lookup file, while another graph is reading from it. The graph that is reading from the lookup gets "killed" by the graph that replaces the lookup.

thanks in Adv

HI Frnds - I will explain you job - 1- lkp file -A this lkp file A is used in several files and there is another graph that updates this lookup file ! Occasionally the writting lkp and read will occuer simultanesly in that case the jobs which are reading the LKP file is getting failed- and the error...