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

What is a predefined event?

1082

---

Explain the mapping variable usage example in informatica

1134

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1751

---

Is stop and abort are same in informatica?

987

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1096

---

What is workflow monitor?

1044

---

How would you join a node to the already existing domain?

1110

---

What will be the approach?

963

---

What is the advantage of informatica?

1055

---

What is deployment group?

1185

---

How do you use reject loader.

2585

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1773

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2029

---

Explain pmcmd command usage in informatica

1108

---

What is session task and command task?

1263

---