Hi All,
Let us see how can we import an excel sheet into informatica and loading into an excel with respective business requirement.
For importing an excel file into informatica there are certain pre requisites
1) We need to select the list of column we need to import into informatica and name it as a table (because informatica treats excel as relational table), it can be done by clicking formulas tab and naming it.
2) For the columns which are numeric or decimals make it as numeric else informatica consider it as nvarchar, this can be achieved by select the column and going to format cells and in numbering placing certain decimals to it as shown below.
3) Now creating ODBC connection. Go to ODBC Data Source Administrator and creating a connection for pulling excel files.
4)Similarly creating target connection for the target excel file
Once after the above process is done import the excel files into inforamtica
5) Now importing it into informatica source analyzer and target designer
6) Similarly Import the target excel file
7) Once after creating mapping with the given requirement, to run the workflow need to create ODBC connections
8) It should be created with the following details
Username: PmNullUser
Pwd: PmNullPasswd
Connection String: The name used for ODBC driver creation
9) Similarly create ODBC Connection for target
10) Once after creating these connections assign these connections for source and target in the session
11) After giving respective connections run the workflow.
Thanks,
Ameen.
Let us see how can we import an excel sheet into informatica and loading into an excel with respective business requirement.
For importing an excel file into informatica there are certain pre requisites
1) We need to select the list of column we need to import into informatica and name it as a table (because informatica treats excel as relational table), it can be done by clicking formulas tab and naming it.
2) For the columns which are numeric or decimals make it as numeric else informatica consider it as nvarchar, this can be achieved by select the column and going to format cells and in numbering placing certain decimals to it as shown below.
3) Now creating ODBC connection. Go to ODBC Data Source Administrator and creating a connection for pulling excel files.
4)Similarly creating target connection for the target excel file
Once after the above process is done import the excel files into inforamtica
5) Now importing it into informatica source analyzer and target designer
6) Similarly Import the target excel file
7) Once after creating mapping with the given requirement, to run the workflow need to create ODBC connections
8) It should be created with the following details
Username: PmNullUser
Pwd: PmNullPasswd
Connection String: The name used for ODBC driver creation
9) Similarly create ODBC Connection for target
10) Once after creating these connections assign these connections for source and target in the session
11) After giving respective connections run the workflow.
Thanks,
Ameen.
