Pre-requiste: Create ODBC so that tables can be reverse engineerd.
1. Start the Informatica Desinger using Start-->Programs-->Informatica Power designer 8.6-->Client--> Power Center Designer
2.Connec to the repository by giving the repository user name and password.
3.Click Tools--> Source Analyzer
4.Click on the Sources --> import from Database menu
5. Give the datbase user name and password, click Connect
6. Select the table and press OK to import the table into source Analyzer pane.
7. Click on Tools--> Targer Designer menu
8. click on Targets--> Import from Database menu
9. Connect to database after giving target user naem and passowrd and press Connect button
10. Select table and press OK button which will import the table into target analyzer pane.
11. Select the mapping Designer by selecting Tools-->Mapping Designer
12. Drag the Source table from Source folder into Mapping Designer.It will prompt you to enter teh mapping name. Give a valid mapping name.
13. Drag the Target table from Target folder into Mapping Designer.
14. Map the columns from Source Qualifier to the target by clicking on teh column Source qualifier and dragging the selected column to the target column.
Now the mappings been done, We have to genereate Workflow as next Step.
4 comments:
As I am fresher I have an interest in new technology.so,now I am planning to learn Informatica in your blog i had some interesting concepts about etl tool, it was crystal clear to read keep sharing thanks from Informatica training in chennai
Thanks for sharing this valuable post to my knowledge; SAS has great scope in IT industry. It’s an application suite that can change, manage & retrieve data from the variety of origin & perform statistical analytic on it
Regards,
sas training in Chennai|sas course in Chennai
Actually I like your writing style and the content Was too good, Thanks for sharing this pretty information with us, keep on blogging
Regards,
Informatica training in chennai|Informatica training center in Chennai
Informatica is one of the most trusted and effective ETL software which is known globally. Informatica is one data warehousing ETL tool. Informatica ha very go opportunities for job across the world. Informatica Training in Chennai | Informatica Course in Chennai
Post a Comment