 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. Describe the elements you would review to ensure multiple scheduled "batch" jobs do not "collide" with each other. Latest Answer : Hi GUYS, COMPONENTS>TRANSALATE>READ SAPARATED VALUES component ... U CAN USE THIS EXCEL FOR EXCEL SHEET...................THANKSRAFI CHENNAI ... Read Answers (5) | Asked by : KNR 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 Latest Answer : Hi, we can give parameters,or any validations which is to be done in the start script of the graphor pass all the necessary parameters as graph parameters or sandbox parameters.these parameters are referenced by a "$" sign.eg:${file_id}=AAA .yuppy,Mukund ... Read Answers (2) | Asked by : Godhuly Latest Answer : API and utility are two possible interfaces to databases from Abinitio.we might use API mode when you want to make use of a function that is not available throgh a utility. ... Read Answers (2) | Asked by : Bobby In input dataset i am having 100 records. I want records between 50-75 and i don't want to read 5th record? which component i have to use.. Latest Answer : You have 100 records You want 50-75.In UNIX you can use head and tail command tail - 50f| head -25f ... 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
