Answer / manju

In Informatica 8.6 and above there can be mulitilple
repositories can be created under node.

The domain can have multiple nodes

Answer / amarnath

2 types of repositories can be created
1. standalone
2. Shared or Global repository

Answer / pankaj pandey

It will equal to limit of ports we can enter while creating
any repository. I dont remember limit but answer is
correct :)

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

---

What do you understand by SOA of Informatica?

0 Answers  

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

where actually the usage of push down optimization happens...

2 Answers  

---

What do you mean by channel change?

0 Answers  

---

what are the perameter and variable?

3 Answers   IBM,

---

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

3 Answers   Wipro,

---

Why use the lookup transformation ?

2 Answers   Informatica,

---