Answer Posted / 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

What is joiner change?

1194

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1311

---

what is the complex transformation you used in informatica

2623

---

Can we override a native sql query within informatica?

1092

---

Can you use flat files in Mapplets.

2715

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7237

---

How we can use union transformation?

1104

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847

---

What is the surrogate key?

1365

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5880

---

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

2201

---

how many types of dimensions are available in informatica?

1180

---

I have a flat file, want to reverse the contents of the flat file

1171

---

Briefly define reusable transformation?

1184

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2417

---