Answer / vaibhav jogale

We can achieve this using With clause
insert into TEST_UNIQ (col1,col2)
with Ct_Test as (
select col1,col2,row_number () over (partition by col1,col2 order by col1,col2)Rw_no
from test123)
select col1,col2 from Ct_Test where rw_no=1
/

insert into TEST_DUp (col1,col2)
with Ct_Test as (
select col1,col2,row_number () over (partition by col1,col2 order by col1,col2)Rw_no
from test123)
select col1,col2 from Ct_Test where rw_no>1
/

how to we create datamart?

2 Answers   HSBC,

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

How do you do error handling in Informatica?

1 Answers  

---

what transformations are used for Variable port?

2 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---