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

how tokens will generate?

2195

---

Scheduling properties,whats the default (sequential)

1946

---

What are the new features of informatica 9.x in developer level?

991

---

How do you set a varible in incremental aggregation

1880

---

Explain why we use partitioning the session in informatica?

1085

---

What do you understand by a term domain?

1123

---

Explain the types of transformations?

1059

---

What is a code page?

1172

---

How to start a workflow using pmcmd command?

1242

---

What is joiner transformation?

1007

---

scenario where i can use only concurrent execution of workflow.

3161

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6477

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2300

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1243

---

What is depict expression change?

1111

---