Answer / swetha

Data driven.

Name 4 output files that informatica server creates during session running?

1 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---