Answer / sabyasachi

Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.

how many session run unix environment what command using ?

1 Answers   HCL,

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

what transformations are used for Variable port?

2 Answers  

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

What is the need of an ETL tool?

0 Answers   Informatica,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

How will you combine 3 different sources with a single source?

3 Answers  

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---