In case of flat file I dont want to load first 5 rows in the target? It must load from the 6th record. Can anyone help me out.

NOTE : [This question was asked by Vinoth]

then put the number 5 when u import the file, the designer will ask no. of rows to skip.
there givn 5 .it will skip 5 rows and start loading from 6 row.

Hi,

Logic
------

SRC----EXP-----FIL------TGT

In expression create one varaible port(V_SEQ_NO)

STEP 1: Write this expresssion in variable pt->
IF(ISNULL(V_SEQ_NO),1,V_SEQ_NO+1)
STEP 2: Pass this port to FILTER
STEP 3: In Filter condition, V_SEQ_NO = 6

Please get back to me in case of queries.

Thx & Regards,
Prakash

take filter after s.q and filter first five records.

take expression transformation in that generate sequence by usin variables after that put filter and filter first five records.

With what Chiru........!

Please follow the step given by cme_prak

__________________
Sanghala
www.dwforum.net - A Great resource for Data Warehousing Professionals

If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.