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

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

What are the modules in Power Center

0 Answers  

---

what is metadata?

6 Answers  

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

What is a mapplet/worklet in informatica?

0 Answers  

---

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---