Answer Posted / srikanth

id sal

101 1000

102 1000

103 1000

104 1000


select id, sal from emp where rownum<=3

minus

select id, sal from emp wwhere rownum<=2;

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10318

---

What is a grid in Informatica?

1116

---

Briefly describe lookup transformation?

1094

---

Explain the code page compatibility?

1117

---

What does update strategy mean, and what are the different option of it?

1140

---

how to load rows into fact table in data warehouse

1228

---

Which development components of informatica have the highest usage?

1098

---

explain abt ur project architecture?

2232

---

What is the advantage of informatica?

1123

---

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

2103

---

Define mapping and session?

1088

---

What is enterprise data warehousing?

1105

---

update strategy transformation in informatica

1122

---

What is the function of aggregator transformation?

1134

---

Explain what is informatica metadata and where is it stored?

1107

---