Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

in my source table i want to delete first and last records and
load in between records into target? how can it possible?

Answer Posted / venkatesh

the flow will be like this
sequence generetor
|
source--->sq--->aggrigator---->filter--->target

generate sequence number using the sequence generator
connect it to the aggrigator and the flow from sq.group by
sequence num and create two o/p ports
1)min(seqnumber)
2)max(seqnumber)
in filter write the condition as
seqnumber<>min AND max

connect the required ports to the target

u will get the required o/p

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle decimal places while importing a flatfile into informatica?

1192


How many ways are there to create ports?

1329


What are the types of presistent cache in look up tr.

2055


Explain the shared cache and re-cache?

1114


Explain what transformation and how many are there in informatica?

953


What are the different transaction levels available in transaction control transformation?

1202


How do you migrate data from one environment to another?

1095


Explain the pipeline partition with real time example?

1143


Can we change Dynamic to Static or Persistent cache? If so what happens?

2210


Differences between connected and unconnected lookup?

1218


What is workflow? What are the components of workflow manager?

1177


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1106


What is the reusable transformation?

1047


How can we use mapping variables in informatica?

1063


Whats there in global repository

1692