Answer Posted / nag

Hi,

I think this scenario will help u.
Source - SQ Trans(2 Instances)-target(2 different targets)

In one of the Instances of SQ Trans write this Query:

select distinct <field name>......from <table name>;

Note:- It fetches only unique records.

In another Source instance write the following query:

select * from <table name> where rowid not in (select max
(rowid) from <table name> group by <field name>);
ex:- select * from emp where rowid not in (select max
(rowid) from emp group by ename);

Note:- It fetches only duplicate records.

then pass the fields to the targets(u should take different
targets).

I hope this will work.

Thanks and Regards,

Nag

Tell me about MD5 functions in informatica

894

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1242

---

What is meant by incremental aggregation?

1053

---

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

4094

---

Explain incremental aggregation in informatica

1091

---

What is the benefit of partitioning a session?

1127

---

Have you worked with/created Parameter file

1635

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6079

---

How to create the source and target database connections in server manager?

1057

---

What is resilience time?

1075

---

What are the new features of Power Center 5.0?

1726

---

What is a node in Informatica?

1014

---

How can repository reports be accessed without sql or other transformations?

1182

---

Define Pmrep command?

1014

---

what is the hint? how to use it to reduce the query processing in program?

7699

---