Explain the flow of data in Iinformatica?
Answer / 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 |
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
h0w many versions have been developed of onformatica so far?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
guys which is the best institute in banglore to learn informatica??
How to recover sessions in concurrent batches?
How Union Transformation is an Active Trans?
Differences between connected and unconnected lookup?