Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

---

Can there be sub steps of etl steps?

0 Answers  

---

what is the meaning of upgradation of Repository?

0 Answers   IBM,

---

Compare etl & elt?

0 Answers  

---

what is the difference between cardinality and Nullability?

0 Answers  

---

---

What is granularity? Please explain with example

1 Answers   IBM,

---

Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  

---

What is Data Vault???

0 Answers  

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  

---

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

---

In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  

---