a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

Explain the different lookup methods used in informatica?

0 Answers  

---

what is mean by throghput? in informatica

3 Answers   Cap Gemini,

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---

what is plsql table?

2 Answers  

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,

---

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---