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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / balu

Answers were Sorted based on User's Feedback



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

Answer / yaseen

After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1

Is This Answer Correct ?    7 Yes 2 No

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

Answer / spandita

After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....

Is This Answer Correct ?    3 Yes 0 No

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

Answer / 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

More Informatica Interview Questions

State the differences between sql override and lookup override?

0 Answers  

What are the mapping paramaters and mapping variables?

1 Answers  

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

Explain how to import oracle sequence into informatica?

0 Answers  

What are the informatica performance improvement tips

0 Answers   Informatica,

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

What are the types of lookup transformation?

0 Answers   Informatica,

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

how you will maintain version?

3 Answers   CTS, TCS,

Can you start a session inside a batch individually?

2 Answers  

For more Informatica Interview Questions Click Here
Categories