How to eliminate duplicates from flat file..what is the procedure

4 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

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,

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

---

How to delete duplicate row using informatica?

0 Answers  

---

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

What is the use of transformation?

0 Answers  

---

What do you mean by channel change?

0 Answers  

---

How to use pmcmd utility command?

0 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

how do u move the code from development to production?

6 Answers  

---