Even though we chose the DimProducts, we may not need every one of the sections present in that table. To determine this, we can alter the table by Right-click on the table definition and choosing the Edit. choice from the setting menu. 

When you select the Edit. alternative, another window called Edit tables will open. To modify or change the current table, we need to explore to Columns Tab. 

For instance, assuming you need to add new segments then, at that point, please select the button and add Column Name, Data Type, Precision (whenever required), Scale (if necessary), If it is an essential key then, at that point change the Key kind to essential and checkmark the Not Null choice (if your segment doesn't permit invalid qualities) 

Assuming you need to erase a couple of segments, then, at that point select the undesirable segments and click the scissors button. Here we are eliminating a couple of sections for the showing reason. When you complete altering, Click OK to close the Edit tables window 

Flat File Source in Informatica

You can check that whether we effectively erased the undesirable sections from the source definition. 

Before we begin bringing in information from the level document into Informatica, let us see the information inside the level record source. 

Import the level record source and Comma-delimited content document as the Flat File Source in Informatica. 

Before we begin anything, first interface with Informatica archive administration with your Admin accreditations and afterwards Navigate to Source Analyzer. 

When you are in Source Analyzer, please explore to Source menu and select the Import from File. choice 

When you select the Import from File. option, another window called Open Flat File will open. If it's not too much trouble, select the necessary level document from your neighbourhood record framework and click the Open button. For this Informatica model, we are picking the GeoImport.txt document. 

When you click the Open button, another spring up window called Flat File Import Wizard will open. This wizard can assist us with determining the content arrangement without any problem. 

To start with, under the Choose the record type that best portrays your information area, we need to pick either a Delimited or Fixed Width alternative. Our content is isolated by a comma delimiter. So, we are choosing a Delimited choice. 

On the off chance that your level record contains section names as the primary line of information like our model document then, at that point, you need to change the Start Import at Row esteem from 1 to 2; in any case, keep it as 1. If you neglected to change, while sending out this information to the data set, Typecasting blunders will toss. 

Import documented names from the primary line: This alternative permits us to import the segment names from the principal line of a level record. On the off chance that your level record contains section names as the primary line of information like our model document then, at that point, by choosing this alternative will import segment names, and this consequently changes the Start Import at Row esteem from 1 to 2 

Stage 2: 

Under the Delimiter segment, pick the delimiter utilized in this content record. Our content is isolated by comma delimiter, as we showed prior, so we are choosing Comma. 

Under the Text Qualifier area, we are choosing No statements because our level record doesn't have any references. Kindly change according to your necessities. 

Here, we can alter the Column Name, Data type, Length or Precision, Scale, and Width. As a general rule, we don't do that, however assuming you need it, you can do it. 

under the Source subfolder, you can notice our recently made Flat File source in Informatica and the table definition (Column Names and proper information types) inside our work area. 

Even though we made our Flat File source, before we continue further, we should review our information. To see the source information, Right-click on the table definition, and select the Preview data. alternative from the setting menu. 

When you select the Preview data. choice, the Preview data window will be opened. If it's not too much trouble, select the GeoImport.txt record as a Flat Filename from your neighbourhood document framework and click the Open button. 

When you effectively chose your document, information inside the level record (e.g., xyz.txt) 

Alter existing Flat File Source in Informatica 

Even though we picked the xyz.txt record as a source definition, there are numerous circumstances where we may not need every one of the sections present in that table. Or on the other hand, we might need to add additional sections. 

To determine these sorts of circumstances, we can alter the table by Right-click on the table definition and choosing the Edit. Option from the setting menu. 

When you select the Edit. alternative, another window called Edit tables will open. To adjust or change the current table, we need to explore to Columns Tab.

For instance, assuming you need to add new sections then, at that point, please select the main button (before scissors image) and add Column Name, Data Type, Precision (whenever required), Scale (if necessary), If it is essential key then, at that point change the Key sort to essential and checkmark the Not Null choice (if your segment doesn't permit invalid qualities) 

Assuming you need to erase segments, then, at that point select the undesirable segments and click the scissors button. When altering is finished, Click OK to close the Edit tables window 

Once done it effectively erased the undesirable segments from your level document source definition in Informatica.