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 : [I][This question was asked by Vinoth] [/I]
Printable View
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 : [I][This question was asked by Vinoth] [/I]
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
[QUOTE=JobHelper;7594]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 : [I][This question was asked by Vinoth] [/I][/QUOTE]
take filter after s.q and filter first five records.
[QUOTE=JobHelper;7594]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 : [I][This question was asked by Vinoth] [/I][/QUOTE]
take expression transformation in that generate sequence by usin variables after that put filter and filter first five records.
[QUOTE=chiru4015;32165]take filter after s.q and filter first five records.[/QUOTE]
With what [COLOR="Red"]Chiru........! [/COLOR]:mad:
Please follow the step given by [B][COLOR="SeaGreen"]cme_prak[/COLOR][/B]