Answer / raj

For maintaining the complete history we need to look up on
the target table especially in sales and banking projects we
use SCD2 type mappings for maintain the complete history.

Answer / sunil reddy

Thankd for your reply.

Could you please explain me about transaction code?

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

0 Answers   Informatica,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

---

---

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

What are the joiner caches?

3 Answers   Informatica,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---

Explain the flow of data in Iinformatica?

1 Answers  

---