Answer / swetha

When the informatica server runs in the ASCII data movement
mode it sorts session data using Binary sortorder. If yoU
configure the seeion to use a binary sort order, the
informatica server caluculates the binary value of each
string and returns the specified number of rows with the
higest binary values for the string.

what is session override?

2 Answers   Cap Gemini,

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

What is a code page?

0 Answers  

---

All active transformations r passive or not?

7 Answers  

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

---

what is fact table?

9 Answers  

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

What is different between the data warehouse and data mart?

0 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---