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 can we load first and last record from a flat file
source to target?

Answer Posted / hardeep

We can use below configurations to achieve desired output. We need 1 SQ, 1 SGen, 2 Rank and 2 Trgt Defn(same Trt). I think it will be cheaper.

Src-SQualifier-->
|
Rank1(Top 1st) -->Trgt1
--->
Rank2(Bottom 1st) -->Trgt2
|
SGen(NEXTVAL)-->

Is This Answer Correct ?    14 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about MD5 functions in informatica

983


What is meant by active and passive transformation?

1192


What is source qualifier transformation in informatica?

1064


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1080


What is confirmed fact in dataware housing?

7104


What are the prerequisite tasks to achieve the session partition?

1295


Explain sessions?

1140


Different circumstance which drives informatica server to expel records?

1041


How many ways are there to do 'remove duplicate records in informatica'?

1065


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1171


can we override a native sql query within informatica? How do we do it?

1186


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2187


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

2046


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

1311


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071