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.

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

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

0 Answers   HP,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

What is predefined event?

1 Answers  

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---