write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

Write the program through which the records can be updated?

0 Answers  

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

What is exclusive and normal mode for repository services?

0 Answers  

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---