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

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

What is the difference between router and filter?

0 Answers  

---

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

What are the joiner caches?

3 Answers   Informatica,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---