Answer / mike

session override is an option in informatica at session
level. Here we can maually give an sql query which is
issued to the database when the session runs. It is nothing
but over riding the default sql which is generated by a
particular transformation at mapping level.

correct me if i was wrong

Answer / guduri

i think mike is correect

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

---

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

How to elaborate tracing level?

0 Answers  

---

What is the benefit of partitioning a session?

0 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

What are differences between Informatica 7.1 and 6.1

3 Answers  

---