Answer Posted / nmlabsonline.net
I)go to create repository.
II)configar the Informatica server in workflow manager.
III)
1)create folder in repository manager.then exit
2)Go to designer connect Repository then open folder select
source go to upper toolbar select tools--->source ok
autometically comes upper toolbar source.
3)go to upper toolbar select source--->import source then
give ODBC connection then after import source from which
database you wont,select tables then ok.
3)same as target table go to upper toolbar select tools---
>warehouse designer ok, auto metically comes target in
upper toolbar
4)select upper toolbar targets import metadata table
through ODBC connection then ok
5) then after upper toolbar tools--->mapping designer
select ok, autometically comes upper toolbar mapping comes
6)select mapping create ok
give mapping name then after select source in leftside
navigater source table drag and drop and same target table
drag and drop autometically comes source and source
Qualyfier then give link SQ to target(TGT) table link grag
and drop then save repository its valid or not check its
valied go to next step other wise check again
IV)go to work flow manager
connect repository select folder create same as itis
session give session name and link to mapping it
autometically asking which mapping you want then after same
as itis workflowdesigner select workflow then give name
then ok
after drag and drop session then after give link in upper
toolbar tools in linktask ok
then session doubble click then after select upper toolbar
select mappings give source path and target path then after
save and ok then save repository workflow toolbar start
work flow
autometically comes work flow moniter
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to create or import flat file definition in to the warehouse designer?
What is Index Caches size?
what are the deliverables?in your project?
According to his methodology what all you need before you build a datawarehouse
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How are indexes created after completing the load process?
How do you remove duplicate records in informatica? And how many ways are there to do it?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is song in infrmatica...?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
wat are deployement groups in informatica, how it will be used for developers
How does a sorter cache works?
how to load dimension table and fact table. plz tell me the steps.
