Answer Posted / vinod kumar

copy the source for 3 times then total 4 sources will be
there in your mapping and move all sources to the target you
will get 4 times of same data in target

What is the benefit of partitioning a session?

631

---

What is decode in static cache?

596

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1467

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1840

---

Explain target update override in informatica

631

---

---

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?

1240

---

Explain the mapping variable usage example in informatica

635

---

What is flashback table ? Advance thanks

1481

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

700

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1623

---

What is option by which we can run all the sessions in a batch simultaneously?

667

---

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?

1055

---

What is status code in informatica?

588

---

Explain constraint based loading in informatica

661

---

What are the differences between source qualifier and joiner transformation?

601

---