How can we increase the loading performance of oracle table in AbInitio?

1105

---

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1619

---

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1436

---

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1679

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

973

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

994

---

How do you improve the performance of the Cognos Analytics report

993

---

What will be the skew for, input file->partition by key-> partition by round robin->output file

926

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

904

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

768

---

what is the output when -1 is put in select_expr of FBE?

1382

---

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1040

---

Code check-in and check-out commands in AbInitio

4266

---

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

946

---

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

917

---