in sequential file stage go to filter option there write unix command..
sed -e '1d' -e '$d'
so that this command will filter ther first and last row of file and then you can load into target....
regards,
radhakant(@HCL)
Search found 3 matches
- Mon Dec 27, 2010 5:57 am
- Forum: General
- Topic: load the data by excluding first and last record in source
- Replies: 5
- Views: 3164
- Mon Dec 27, 2010 4:14 am
- Forum: General
- Topic: loading data in different targets
- Replies: 5
- Views: 3119
- Mon Dec 20, 2010 4:12 am
- Forum: General
- Topic: loading data in different targets
- Replies: 5
- Views: 3119
hi i am completely Agree with above answer here i am giving new solution for loading into different target in cyclic order of 3.. take transformer after source data and generate a sequence order and store into a variable say Sv and write three constraint . 1)Sv=1 or mod(sv,3)=1 2) Sv=2 or mod(sv,3)=...