Answer Posted / amit kumar

When the Integration Service runs in the ASCII data
movement mode, it sorts session data using a binary sort
order.
When the Integration Service runs in Unicode data movement
mode, the Integration Service uses the sort order
configured for the session. You select the session sort
order in the session properties. The session properties
lists all available sort orders based on the code page used
by the Integration Service.
For example, you have a Rank transformation configured to
return the top three values of a string port. When you
configure the workflow, you select the Integration Service
on which you want the workflow to run. The session
properties display all sort orders associated with the code
page of the selected Integration Service, such as French,
German, and Binary. If you configure the session to use a
binary sort order, the Integration Service calculates the
binary value of each string, and returns the three rows
with the highest binary values for the string.

State the limitations where we cannot use joiner in the mapping pipeline?

1105

---

Why is sorter an active transformation?

1194

---

How big was your fact table

1856

---

What is aggregate cache in aggregator transformation?

1198

---

Did u used latest transformations of 8.6.0? for what?

1924

---

Does an informatica transformation support only aggregate expressions?

1086

---

What is a shortcut and copy in Informatica and how two are different with each other?

1236

---

Is it possible to revert a global repository to local one and why?

1129

---

What are the tuning techniques you applied during your last project

2072

---

Scheduling properties,whats the default (sequential)

2007

---

Is it possible to create multiple domains on a single Informatica server?

1286

---

Explain what are the different versions of informatica?

1143

---

What are active transformations.

1702

---

What is the advantage of informatica?

1123

---

What is blocking transformation?

1186

---