-
Notifications
You must be signed in to change notification settings - Fork 1
/
create-populate-datastore-files.html
44 lines (36 loc) · 1.48 KB
/
create-populate-datastore-files.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Oracle Data Integrator (ODI) 12c - Create a Datastore</title>
</head>
<h3>Oracle Data Integrator (ODI) 12<em>c</em></h3>
<ul><li>Create a Datastore - Manual Way</li></ul>
If you have a blank model and a flat file, here is how you can manually create and populate a datastore.
<br></br>
<or>
<li>Go to the Designer Navigator and choose a model or sub-model</li>
<li>Right click and choose New Datastore</li>
<li>On the definition tab, name the datastore, resource name and alias</li>
<li>For flat files: on the File tab go to file format and choose the type, fill in if there is a header, record separator and field separator define the characters used to separate the lines and then click save</li>
</or>
<br></br>
Now the datastore is created.
<br></br>
Reverse-Enginnering Fixed File Datastores
<br></br>
<ol>
<li>Go to the Attributes tab that has a fixed format</li>
<li>Click the Reverse-Engineer button</li>
<li>Click on the riler to create marketing delimited the attributes</li>
<li>Attributes are created with pre-generated names - edit by clicking in the header line</li>
<li>You must set the Attribute Name, Datatype and Length for each attribute (no spaces) and click ok</li>
</ol>
<br></br>
Reverse Engineer Delimited Files:
<ol>
<li>Go to the Attributes tab</li>
<li>Click reverse-engineer</li>
<li>Edit the attributes according to your content and save</li>
</ol>
</html>