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

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,

Explain how to import oracle sequence into informatica?

0 Answers  

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

How to do unit testing in informatica?

0 Answers  

performance wise which one is better in joiner and lookup transformation

2 Answers  

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

What are the various types of transformation?

0 Answers  

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

what is confirmed dimension?

6 Answers  

How is Data Models Used in Practice?

1 Answers  

what is the complex transformation you used in informatica

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories