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.

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,

---

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---