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

How to load only the first and last record of a flat file into
the target?

Answer Posted / harish konda

First connect the exp1 with source and Sequence t/f's.

And next take the sorter and sort the data in descending
order of NEXTVAL port.

And again connect sorter to exp2 and connect sequence t/f to
this exp2.

And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the aggregator transformation?

1089


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1923


How to update source definition?

1030


What is the difference between STOP and ABORT options in Workflow Monitor?

1172


How to use pmcmd utility command?

959


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1727


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

948


Different circumstance which drives informatica server to expel records?

913


What if the source is a flat-file?

1041


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1905


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1925


How to implement security measures using repository manager?

1078


Explain pushdown optimization and types in informatica

1011


Make a note of the quantity vaults made in informatica?

939


Which transformation is needed while using the Cobol sources as source definitions?

1123