Loading for 6th Record

[JobHelper]

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]

[nkalis]

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.

[cme_prak]

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

[chiru4015]

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]

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

[chiru4015]

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]

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

[sanghala]

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

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

Please follow the step given by cme_prak