What are the data movement modes in informatcia?

1 Answers  

---

what is bridge tables in informatica

1 Answers   CTS,

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

what is session parameters?

1 Answers   Cap Gemini,

---

What if the source is a flat-file?

0 Answers  

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

Define Incremental Aggregation?

2 Answers  

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---