What are the data movement modes in informatica?

0 Answers   Informatica,

---

Diff b/w ShortCut and reusabel Object ?

4 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,

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

How to extract original records at one target & Duplicate records at one target?

12 Answers  

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---