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

What happens when a session fails and you click on recover?

1093


How would you copy the content of one repository to another repository?

976


How do you use reject loader.

2567


what are the deliverables?in your project?

2110


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1245


Quickly characterize reusable change?

1077


What is InformaticaPowerCenter?

1095


Informatica settings are available in which file?

951


Explain why we use partitioning the session in informatica?

1039


Why do we need informatica?

950


What is meant by active and passive transformation?

1071


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2244


what are factless facts? And in which scenario will you use such kinds of fact tables.

1761


Why filter transformation is an active one?

948


What are the types of caches in lookup? Explain them.

940