Answer / shalaka kulkarni

When work flow starts integration service retrieve mapping ,workflow ,and session form repository,It extract data from mapping sources and store in staging area apply transformation logic .then load it into target according to requirement. For that it uses three components:
Integration service process
Load balancer
DTM process

Answer / uday

Hi, What is the staging are here you are speaking
about...Is that on Informatica server database OR soruce
database OR target database?

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

What is target update override

2 Answers   CTS,

---

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

---

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

0 Answers  

---

tell me the rules and responsblites in our project(my project is development)

0 Answers  

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---