Answer Posted / gopi k

rownum is pseudo column, when query extracts rows rownum
will be appended to query. So where rownum = 3 condition is
a wrong one.

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1052

---

Target increases every day even though no new record was inserted

1516

---

What are the transformations that are not supported in mapplet?

959

---

How can we update a record in the target table without using update strategy?

1089

---

difference between informatica 8.1.1 and 8.6

3629

---

How many input parameters can exist in an unconnected lookup?

1493

---

Different circumstance which drives informatica server to expel records?

919

---

What is the Rank index port in Rank transformation?

1015

---

How can we delete duplicate rows from flat files?

1165

---

What are the different ways to implement parallel processing in informatica?

1342

---

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?

1916

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2296

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1980

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

---

In informatics server which files are created during the session rums?

1067

---