Answer Posted / hitesh

but in this we ll get distinct values in duplicate table.
how can i get all values in duplicate table like:
col1 col2
1 2
1 2
1 2
3 4
3 4
5 6
and i want
unique table:
5 6
and
duplicate table :
1 2
1 2
1 2
3 4
3 4

i know this is of no use, but can we do this??
pls rply

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1804

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2098

---

How would you join a node to the already existing domain?

1065

---

Reusable transformation and shortcut differences

1778

---

What is target designer and target load order?

1050

---

Define mapping and session?

966

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1094

---

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

4067

---

Can we create a Integration service without a Repository service and vice versa?

1170

---

How can we update a record in the target table without using update strategy?

1086

---

How to load last n records of file into target table - informatica

1018

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1931

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1071

---

What is a rank transform?

1024

---

Is it possible to create multiple domains on a single Informatica server?

1176

---