How to create a sandbox and graph using ab initio components?
So Firstly whenever you want to create some something in ab initio GD, you need to have a sandbox, a sandbox is nothing but a project folder in ab initio. Will explain about How To Create A Sandbox And Graph Using Ab Initio Components ?
This concept How To Create A Sandbox And Graph Using Ab Initio Components is Easy . please Concentrate . So first, let’s see how to create a sandbox. So for that, as soon as you open your abinitio gd, you’ll be seeing few options here, file, view, Project Settings, window enhance.
How To Create A Sandbox And Graph Using Ab Initio Components ?
So go to the project option, there, you will be finding a create sandbox option. So just go to the project type, and click on basic sandbox. And then go to the directory path, which is under sandbox and create a new folder. And just click on that folder, select.
And if you want this particular sandbox to be a reusable sandbox, that means if you want some other sandbox, using this particular sandbox, you just need to give a parameter prefix. So here I’ll be giving parameter prefix as test two. So now the sandbox is created . So this is how we create a sandbox. Now our sandbox is ready, that means our project folder is ready. ( How To Create A Sandbox And Graph Using Ab Initio Components )
And we are ready to create a graph. So let’s see how to create a graph. And a graph is nothing but a group of components connected as per the business logic to load the data into data Mart’s that according to the business logic, so let’s see how to create a sample graph. So for this, you actually need to open the sandbox. Now we are actually in the sandbox that we have created recently, then click here, then click on the graph.
So sample graph is created here. Now let’s create a sample graph, which actually loads of data from one flat file to another flat file. So for that, what we need is, as I said, our sources of file, we need to drag input file component here. And then to map columns. We need a reformat component, which is used to map columns from source to target and also to do some expressions on the source to do some transformations on input rows records. And to store the output, we need an output file.
So for that , the statements file assertion file, you will be seeing an output file component here, just drag and drop it here. So the elements that you see here means this is actually waiting for this particular value to be assigned. So I’ll just map these columns initially. And then I’ll edit my source company name. And my output file is f1 score TGT.
So once I double click there, we actually need to specify what is my source free. So here, my source file is m n dot dat, where I will be having my records there, and the port you’ll see an output read here. So the question mark here says, How I have to read my source file.
So for that, you have to create a DML you have to create a source DML which actually describes the structure of your source file. So here, you just need to click click on use file and go to your sandbox. The DML and my source DML is RR underscore m dot DML. So now you see the source input file component is not waiting for anything. Now I’ll be going to the reformat here. ( How To Create A Sandbox And Graph Using Ab Initio Components )
Here I can select few options. Were first thing I have to provide the transformation file That means the Excel file where my business logic exists. So click on the transform here and click on use file. Now I have to give the Excel file my business logic. And then you’ll have an option called I mean when to abort your draft, either to abort on the first reject or never abort, or you can set a limit, like abort on the first row abort on the second reject, or third is some kind of thing.
Here, I want my graph to be aborted on the first error, then I’ll have my ports there in the output, you will see a question mark here again on the output. So this means it’s asking me how I have to create my target output file. So for that, click on use file and click on this. An RM is called m DML is my target structure.
Then done, now I will be going to the output file component. And here, I have to give the path we’ll have to create my output file. So for this, I just give this part here. In the temp directory, I’m planning to create an output file with M underscore target dot dat. So this is my output file name. And this is a part where I’m actually asking my graph to create a target file.
And then here, you will be having file handling options where you’re not the graph, he said, like, if there is no file existing with the output file name that I’ve created, then I’m asking it to create a file. And if the file exists, I’m asking my draft to delete and recreate the file. And these are the permissions that you can grant on the output file created. And then this is my output file structure. So now my graph is complete. And I will be storing this as MP underscore test. This is How To Create A Sandbox And Graph Using Ab Initio Components . ( How To Create A Sandbox And Graph Using Ab Initio Components ?
Note: Browse latest Ab Initio Interview Questions and Ab Initio Tutorial Videos. Here you can check Ab Initio Training details and Ab Initio Training Videos for self learning. Contact +91 988 502 2027 for more information.