ODI 11g: Implementing Loops

DZone Database Zone

ODI 11g: Implementing Loops

While using ODI to implement your ETLs, you may need to have loops. Let’s look at some examples where I will implement loops that will iterate n times (for loops) and loops that will iterate while they ensure the condition (while loops).

For Loop

In programming, we implement for loop as follows:

more info...