What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---

What are roles and groups and benefits of using them?

0 Answers  

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---