How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

What is a snowflake schema?

0 Answers  

---

Why do we need informatica?

0 Answers  

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

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,

---

what is upstream and downstream transformation?

7 Answers  

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

---

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

---