Answer / bsgsr

An instruction given to the Informatica server the order in
which the sources are to be read and the targets are to be
loaded. It is found in the mappings tab of the mapping
designer tool.target load order is possible only when we
have multiple sources.

Reach me on bsgsr12@gmail.com..............
Kum lets share and be instrumental to one another in
getting a break with the industry.

Answer / prabhu

If u have a multiple source qualifier connected to the
multiple target, then you have specify the order in which
target the informatica server loads the data first.

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

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 SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

"Change cache" in Informatica ?

2 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---