Answer / vali

to improve the session performance we use the session
partitioning.it improves performance by giving multiple
connections to the source and target.

there are five types of partitioning the session
pass through
data base
round robin
key range
hash partitioning..

Answer / g. manthiramoorthy

Partition Types:
1.Database partitioning.
2.Hash auto-keys.
3.Hash user keys.
4.Key range.
5.Pass-through
6.Round-robin.

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

Explain target update override in informatica

0 Answers   Informatica,

---

Can you start a session inside a batch individually?

2 Answers  

---

What is Target Update Override? What is the Use ?

8 Answers   Patni,

---

What is meant by lookup transformation?

0 Answers  

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---