how to get particular record from the table in informatica?


using a where clause


and to get the records starting with A..write an SQL query in Source Qualifier transformation as..

SELECT * FROM TABLENAME WHERE ENAME LIKE 'A%';