Answer / 9019

Predefined we can see event wait task.
1. it will wait for file it also called file watcher

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---

How can you recover the session in sequential batches?

1 Answers  

---

how many types of dimensions are available in informatica?

0 Answers  

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---