Answer Posted / bala ramesh

in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.

What is a shortcut and copy in Informatica and how two are different with each other?

1208

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1074

---

Explain the pipeline partition with real time example?

1152

---

What are the types of caches in lookup? Explain them.

979

---

What is a pre-defined event and user-defined event?

1051

---

what is index?how it can work in informatica

2049

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2353

---

What is mapping debugger?

1025

---

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

2370

---

What is the maplet?

1133

---

where to store informatica rejected data?

1105

---

Performance tuning in UNIX for informatica mappings?

2576

---

How can we improve session performance in aggregator transformation?

1126

---

Write the unconnected lookup syntax and how to return more than one column.

1121

---

Explain the types of lookup transformation?

1056

---