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

One flatefile it contains some data but i want to dont want
to load first and last record ..how it is? can u tell me
complete logic?

Question Posted / rv

Answers were Sorted based on User's Feedback



One flatefile it contains some data but i want to dont want to load first and last record ..how it ..

Answer / ashok nidamanuri

We can implement like this
1)Take sequence genarator transformation and get sequence
of no's for each and every record
2)Then in expression take two output port's like out_min
and out_max.Assign Min and Max functions to corrsponding
output ports then u will get Min and max value of the
records
3)Take filter transformaton and filter those two records in
filter tarnsformation.

try with this!!!!!!!!!!!!!!!!!!!

Is This Answer Correct ?    3 Yes 6 No

One flatefile it contains some data but i want to dont want to load first and last record ..how it ..

Answer / purushothaman

put one expression after the source qualifer
and type this code

for example take this record
HDR20008
....
TRL2000800020

output variable name = IFF(SUBSTR(columnname ,1,3)
='HDR','Y','N')
Similarly put for trailer record condition in the
expression

after this expression put the one filter like this
output variable name ='Y'


cheers!!!!!!!!!!!!!!!!!

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Informatica Interview Questions

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

What is the difference between a connected look up and unconnected lookup?

0 Answers  

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

how many session run unix environment what command using ?

1 Answers   HCL,

Explain what are the different types of transformation available in informatica.

0 Answers  

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

What is difference between a gateway node and worker node?

0 Answers  

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

What is the surrogate key?

0 Answers  

For more Informatica Interview Questions Click Here
Categories