Unable to complete Oracle example for ODI Flat File to Flat File Export
Hi I am new to ODI and I have installed ODI 11g and have created Master and Work Repositories using the Oracle tutorial here
After this I followed the tutorial they have provided here to create ODI Project and Interface for exporting a Flat File to a Flat File. I was able to execute several steps in this tutorial before I reached at step 4 under the heading Creating a New ODI Interface for Flat File to Flat File Transformations
Here is the mapping flow which I got after following all the steps in this tutorial and it is totally different from what they showed in this step: 
As per this tutorial I am supposed to Click the SS_0 (1 - FILE_GENERIC) source datastore. This makes the properties for the source appear below. In the LKM Selector section, select LKM File to SQL from the LKM drop-down list if not already selected. but I cant see anything like that.
Please help if anyone knows the reason for this. May be I am missing something or would have done something wrong.
You probably missed a part of the second step of that section.
Click on the Overview tab and choose "In-Memory Engine: SUNOPSIS_MEMORY_ENGINE" as your staging area. Then go back on the flow tab and you should see three separated groups instead of one. Click on the Datastore of the group in the middle (the Staging Area) and there you can set your LKM.
The reason we need to select a different staging area is because usually ODI will try to let the underlying technologies doing most of the job. If you load an Oracle database, ODI will generate SQL code and let the database execute it itself. This is not possible with the File technology as a file can't execute code by itself. So instead we will do the transformation and the loading using the In-Memory Engine of ODI, the SUNOPSIS_MEMORY_ENGINE.
This SUNOPSIS_MEMORY_ENGINE is actually an HSQL Database. It's in the memory of the JVM of your agent (or ODI Studio if you use the local agent).
- How do nested functions get compiled?
- The "this" pointer and message receiving in D
- 64-bit executables with DMD
- GtkD with D lang on Fedora
- Why Android used Java concept instead of D language or C or C++? But Chromium web browser is in C++, its very complicated match
- How to use MongoItemWriter to write a List<T>
- Why a function with protected modifier can be overridden and accessible every where?
- Convert Unicode const(uint)* to a dlang character type
- Compiling D with Code::Blocks
- DMD vs. GDC vs. LDC
- Rendering a font in raylib using freetype
- Digital Mars D compiler; acquiring ASM output
- D Programming: openssl rsa forward reference compiler error
- D compiler DMD doesn't link object files
- OPTLINK: Warning 23: No Stack
- Is there a limit in the amount of temporary generated symbols during a project build using dmd 2.063?
- Is this the right way to combine Garbage collected with none Garbage collected code in D
- D compiler (Digital Mars D Compiler) throwing error
- Which D Compiler to Use?
- Splitting a string treating multiple whitespace as one separator
- Proper way of passing array parameters to D functions
- Detailed Valgrind internals documentation
- Is it possible, in D, to tell the garbage collector to not scan a particular pointer (or anything below it)?
- Iterate over key/value pairs in associative array in D.
- Dlang associative array of an array of strings keyed by a string has unexpected behavior
- How to repeat a statement N times (simple loop)
- Is worth the effort to learn D?
- ld: undefined reference to object I can see in objdump
- D using emplace
- How can I return JSON with HTTP code in Vibe.d?