Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

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,

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

---

---

What is a code page?

0 Answers  

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

why we use materialized view over view?

1 Answers   Zensar,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---