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

What are the restrictions of union transformation?

1039


What are the mapping parameters and mapping variables?

1204


What is joiner transformation in informatica?

1045


What is primary and backup node?

1127


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7388


What is the difference between router and filter?

1268


Explain the code page compatibility?

1063


what is informatica metadata?

1035


How can we handle two sessions in informatica?

1031


What are the features of complex mapping?

1156


What are the measure objects?

1202


What is flashback table ? Advance thanks

1932


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1901


How do you load unique records into one target table and duplicate records into a different target table?

1255