why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

How do you implement scheduling in Informatica?

1 Answers  

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

How do you load first and last records into target table?

0 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

---

why we use source qualifier transformation?

16 Answers   Accenture,

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---