Submitted Questions

  • Memory requirement of graph

    How can I calculate the total memory requirement of a graph?

    robmuza

    • Jul 10th, 2008

    When we did some benchmarking we found that it was closer to ~8MB + MAX_CORE (if any) per component and add in the file sizes.Basically, I agree with the existing answer.Just remember, don't use &...

  • Cummulative summary in AB Initio

    How can I achieve cummulative sumary in AB Initio other than using SCAN component. Is there any inbuilt function available for that?

    mk_44

    • Feb 9th, 2016

    I guess below code can help for 3rd max else 1st max for each group key. Input_file --> sort (descending) --> Rollup --> output type temporary_type=record decimal("") rank ; decimal("") sal ...

    disha

    • Jan 22nd, 2016

    @Dinesh: but it is not taking care of the requirement, i.e. if there is no 3rd record, it should display the first highest sal. In the solution you mentioned it will display the second highest sal.

  • Output for sort and dedup sort with null key

    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.

    Amaan Sajid Ansari

    • Nov 14th, 2018

    In Case of sort output would be same as input (unsorted) in case of dedup will depend on no of partition and the dedup method used. Please refer to the other similar dedup question i have explain it in that

    san

    • Aug 7th, 2018

    1. In case of Null ket{} in sort component nothing will happen. 2. In case of Dedup sorted - keep - fist then you will get first record, Keep- Last then you will get last one, Keep- Unique only - in ...

  • Join on partitioned flow

    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 join or not and WHY?

    Abhishek

    • Feb 5th, 2013

    Yes, this is going to work fine provided u do it as in-memory. Let me explain why, firstly whenever you are using the field A as a key, for the same data in the both the files, would definitely go int...

    vss34

    • Jul 16th, 2009

    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 parti...