Answer Posted / chandra

take 2 agg Trs after SQ and drag all the ports to both the
AGG Trs and enable group by for all ports for one AGG and
take one output port in second AGG ..,in that take count(no)
then take filter and write condition as count(no)>1


SQ---->AGG(enable all ports group by)-->Tar1
---->AGG(count(no))-->FIL(count(no)>1)--->Tar2

Is it possible to revert a global repository to local one and why?

1064

---

Design a mapping to load a target table with the following values from the above source?

1327

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1074

---

What is the scenario which compels informatica server to reject files?

1054

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1307

---

What is meant by incremental aggregation?

1078

---

Explain the difference between mapping parameter and mapping variable?

1021

---

What do you understand by term role-playing dimension?

1029

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1244

---

where to store informatica rejected data?

1080

---

Explain dynamic target flat file name generation in informatica

1036

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1089

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7358

---

What is workflow? What are the components of the workflow manager?

1108

---

What are the data movement modes in informatica?

1133

---