Answer Posted / satish potdar

Use a seq generator to tag row number to each row(use reset
option so that it will be reset to 1 after the session is
complete). OR use rownum in Source qualifier query.
Once the rows are tagged,pass constant 1 to aggregator to
get the count, join the aggregator output with source
pipeline USING JOINER(since you cannot join heterogeneous
rows using any other transformation). Use router to route
the rows to different targets using appropriate group
expression.

What is lookup transformation?

1021

---

What are the tuning techniques you applied during your last project

2012

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1490

---

What is the difference between source qualifier transformations source filter to filter transformation?

1031

---

How we can use union transformation?

1036

---

What is a sorter transformation?

1079

---

Can u generate reports in Informatica?

1058

---

What do you mean by filter transformation?

938

---

What is a stored procedure transformation?

1035

---

What is a router transformation?

1101

---

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

1050

---

What is informatica worklet?

1031

---

What is a code page?

1158

---

Explain about Informatica server process that how it works relates to mapping variables?

1047

---

To import the flat file definition into the designer where should the flat file be placed?

1042

---