list and discuss two approaches for updation of target table in Informatica and how they are different.

0 Answers  

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

0 Answers  

---

Explain about hash partitioning?

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,

---

if i have a query as flat file how can we load data to target table

0 Answers   Tech Mahindra,

---

Explain the use lookup tables and Aggregate tables?

0 Answers  

---

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 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  

---

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

---

What is etl process?

0 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 Answers  

---

what is the difference between date cache and lindex cache?

1 Answers  

---