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 :)

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

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  

---

How do you take care of security using a repository manager

2 Answers  

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---