Usecase: Here, we will see how to import a flat .csv file in ODI studio.
High level steps:
- Under Topology, choose physical architecture >> File Technology and create new data server and new physical schema with the file location.
- Under Topology, choose logical architecture >> File Technology and create new logical schema.
- Under Design >> model >> create new model or use existing model >>select Technology and logical schema
- Under model, create new datastore >> provide resource file name >> files format
- Over data store >> view data
If you want to have variable file name, then create a variable in a project and use it as refresh variable and use it in the model data store resource name as #procjectcode.variablename
Detailed Steps with screenshots:
No comments:
Post a Comment