Answer Posted / venkatesh.malneni

here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r


the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3

or if u use sequence generator the flow will be

sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1086

---

What are the various types of transformation?

1179

---

What is joiner transformation in informatica?

1045

---

How to configure mapping in informatica?

1173

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

---

What the difference is between a database, a data warehouse and a data mart?

1155

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1676

---

What are the restrictions of union transformation?

1041

---

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

1322

---

Name the different lookup cache(s)?

1235

---

Explain informatica architecture - version 8 / 9

1092

---

list out all the transformations which use cache?

1184

---

What are the prerequisite tasks to achieve the session partition?

1252

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

What all join we can perform in LOOKUP transformation?

978

---