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

What is intricate mapping?

0 Answers  

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

what is mapping optimization? wat are the techniques for tat

2 Answers  

What is rank transformation?

0 Answers  

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

How many ways you create ports?

1 Answers  

Parameter and variable differences

0 Answers  

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

For more Informatica Interview Questions Click Here
Categories