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
How can we use mapping variables in informatica?
What is a connected transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is InformaticaPowerCenter?
What is meant by incremental aggregation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How identifying bottlenecks in various components of informatica and resolving them?
How to generate sequence numbers without using the sequence generator transformation?
Why do you use Mapping Parameter and mapping variable?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are data-driven sessions?
Separate from an archive server and a powerhouse?
can anyone suggest best free Talend data integration training online
What is an Integration service in Informatica?
