 Related Questions In the scenario outlined in #18 and given that the output table(s) will be accessed by concurrent readers describe how your SQL code would be structured to minimize lock contention. How to do we run sequences of jobs ,,like output of A JOB is Input to Bhow do we co-ordinate the jobs What are the most commonly used components in a Abinition graph?can anybody give me a practical example of a trasformation of data, say customer data in a credit card company into meaningful output based on business rules?ThanksSri Read Answers (3) | Asked by : ghayathri Tags : Business Rules We have sort and sort within groups components. we can achieve the sort within group functionality by palcing two keys in sort group. then why i go for sort within gropus? If I have 2 files containing field file1(A,B,C) and file2(A,B,D), if we partition both the files on key A using partition by key and pass the output to join component, if the join key is (A,B) will it Latest Answer : The partition key and join key do NOT have to be the exact same. In order to join properly, you just have to make sure the records being compared are in the same partition. So if the partition key is broader than the join key (which it is ... I have file containing 5 unique rows and I am passing them through SORT component using null key and and passing output of SORT to Dedup sort. What will happen, what will be the output. Latest Answer : If there is no key used in the sort component, while using the dedup sort the output depends on the keep parameter.If its set to firt then the output would have only the first record,if its set to last the output would have the last record,if its set ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
