Answer / rohit

I have below records.

EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-

101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship

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  

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

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,

---

What are ETL Tools?

0 Answers   Informatica,

---

why u go for dimensions ?

3 Answers   TCS,

---

---

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

what is incremental data aggregation?

3 Answers   IBM,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---