For beginners, the most effective way to start is by building simple "Read -> Filter -> Write" graphs to understand how data flows between components before moving to advanced concepts like partitioning and parameterization or a deeper look into partitioning strategies
| Action | Shortcut | |--------|-----------| | Add component | Ctrl + drag from palette | | Connect components | Click source, drag to target | | Run graph | F9 | | Stop graph | Ctrl + F9 | | View log | F8 | | Validate graph | Ctrl + Shift + V | ab initio etl tool tutorial for beginners pdf 26
Keep records where new salary ≤ 200,000: For beginners, the most effective way to start
Use Sort component with Crev (external sort) or Sort with in-memory . Always set a key and choose stable/unstable sort. Let's build a graph that reads a CSV
Before opening Ab Initio, you should understand:
out :: begin let date_old = string(in.order_date); let year = substring(date_old, 1, 4); let month = substring(date_old, 5, 2); let day = substring(date_old, 7, 2); out.new_date = month || "/" || day || "/" || year; out.amount = in.amount; out.cust_id = in.cust_id; end;
A is the Ab Initio term for an ETL dataflow. Let's build a graph that reads a CSV file and prints its contents to the screen.