Answer / pawan

Number of reasons can be there:
1. Session Impacts.Its not saved properly.
2. Integration service is not correctly mapped.
3. Connection missing in between source & source Qualifier.
4. Parameter file path is not correctly mentioned.
5. Date conversion is not correctly done.etc.

can you use flat file for lookup table?why?

2 Answers   HCL,

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  

---

how i will stop my workflow after 10 errors

1 Answers   HP,

---

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

2 Answers  

---

What is IQD file?

1 Answers  

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---

When to use normalization transformation other than cobol source?

2 Answers  

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---