top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Informatica: How do u get the first record from 50,000 records?

0 votes
122 views
Informatica: How do u get the first record from 50,000 records?
posted Jul 28, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Hi,

To achieve this output there are many ways:

1) Src --> SQ --> Seq --> Exp --> Fil --> Tgt

So in your Expression Transformation via Sequence Generator your records would get numbered.
And, in your filter you can give condition as NEXTVAL=1, and there is your output.

2) You can write a Query in your SQ Transformation itself.
SELECT * FROM TABLE_NAME WHERE PK=1;
Note: Please specify all the columns in place of *

3) Src --> SQ --> Rnk --> Tgt
Under Properties Tab, Select Top 1.

4) Src --> SQ --> Seq --> Agg --> Tgt
User FIRST function in Agg Trnfn for all Columns

Hope this helps you...If you find my answers useful VOTE on me.

thanks

Arif

answer Jul 28, 2015 by Arif Shaikh
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...