Answer Posted / 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
/

Explain 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?

1017

---

How many ways are there to do 'remove duplicate records in informatica'?

1018

---

tell me about your project functionality

2347

---

Explain pmcmd command usage in informatica

1139

---

What is powercenter on grid?

1181

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2129

---

Design a mapping to load a target table with the following values from the above source?

1349

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

Explain the aggregator transformation?

1169

---

What are data-driven sessions?

1218

---

What are the features of complex mapping?

1161

---

server hot-ws270 is connect to Repository B. What does it mean?

2567

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1178

---

What you know about transaction control transformation?

996

---

What are the differences between source qualifier and joiner transformation?

1064

---