Answer / Aditya Tiwari

Tracing level in Informatica defines the amount of detail logged during a session or transformation. The logging information helps developers and administrators troubleshoot issues, optimize performance, and understand how data is being processed. Levels can range from minimal (0) to verbose (9), with higher levels providing more detailed logs.

What is lookup transformation?

1 Answers  

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

What are the data movement modes in informatcia?

3 Answers  

---

what is INFORMATICA TESTING process

1 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

What is fact table? Explain the different kinds of facts.

1 Answers  

---

Performance tuning in UNIX for informatica mappings?

1 Answers   CGI, CTC,

---

What is the format of informatica objects in a repository?

1 Answers  

---

What are the restrictions of union transformation?

1 Answers  

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---