Answer / nagaraju bhatraju

when we use concurrent process to load when session
fails ...all other session will run normally and load the
data..the failed session will considered as a standalone
sesion ...and we have perform recovery for the failed
session.
there three type where we can recover a failed session

1.start the session again if the Informatica server doesnt
perform the commit

2.else perform recovery on the session

3. if we can recover the session truncacte the data from
target table and run the session.

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

In informatics server which files are created during the session rums?

0 Answers  

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

What is source qualifier transformation in informatica?

0 Answers  

---

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

What are the modules in Power Center

0 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---