Answer / babu

Hi,
If your source is RDBMS,u can writ sql override in
sourequalifier.


select p.*,pc.cno from product p,(select price,count(price)
cno from product group by price) pc where pc.price=p.price;

In RTR group1 cno=1
group2 cno>1

OR
If source is flatfile

SRC-->SQ-->AGG(GROUP BY PRICE,CNO=COUNT(PRICE))
|
SRC-->SQ-->JNR--RTR (GRP1 CNO=1 )-->TRG1
(GRP2 CNO>1 )-->TRG2

Answer / akash

Hi Krish,

In this case we will get distinct records in one table and
one record each for duplicate records of each table.

For ex:
Source:
101 neem
101 neem
101 neem

Duplicate target:
101 neem

Can you suggest any way through which we can get as many
duplicate records as there are in the source?

Answer / honey

Help me out generating count in informatica.

Answer / krish

take AGG t/r and give count on price
and in router count(price)=1 and count(price)>1.

What are the new features in Informatica 5.0?

1 Answers  

---

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

---

Whats the difference between $, $$, $$$

9 Answers  

---

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

---

Can you start a session inside a batch individually?

2 Answers  

---

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

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

0 Answers   Patni,

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---