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  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---