If source qualifier having employee details.the empid is in 5th placle and deptno is in 7th column then. u selected sort by 2. but how the informatica server will come know that those r the fields to sort.

Interview Candidate
Sep 27th, 2006
1
2359

Showing Answers 1 - 1 of 1 Answers

dwinfo
Profile

Sep 27th, 2006

I think the question is :If EMPID is in 5th column/port(in source qualifier), DEPTNO is in 7th column/port(in source qualifier) and if we use No.of Sorted Ports as 2. How will informatica know if it has to sort only those 2 ports ?
OK. Here is the reply to this question.
The Ports EMPID (5th port) and DEPTNO (7th port) should be moved to the first 2 ports by using the arrows which will make the columns move up and down as desired. Make both the EMPID and DEPTNO as first 2 ports and then you could make the informatica understand that its the first 2 ports that should be sorted.