Answer Posted / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1151

---

Do you find any difficulty while working with flat files as source and target?

1151

---

what is index?how it can work in informatica

2087

---

Why union transformation is an active transformation?

1102

---

Explain sessions and how many types of sessions are there?

1061

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1182

---

Explain in detail scd type 2 through mapping.

1092

---

What are the informatica performance improvement tips

1152

---

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

2109

---

Which transformation is needed while using the Cobol sources as source definitions?

1223

---

What is meant by pre and post session shell command?

1202

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5881

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1143

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1322

---

Explain what are the different types of transformation available in informatica.

1252

---