Answer / venkatesh

by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this

source--->aggrigator----->target

in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self

Could any one to tell Fact table Partitioning?

2 Answers  

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

What is A cache?

2 Answers  

---

What are roles and groups and benefits of using them?

0 Answers  

---

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

---

---

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.

0 Answers  

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

How many numbers of sessions can one group in batches?

0 Answers  

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

How the facts will be loaded? explain

2 Answers   HCL,

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---