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]
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