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

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Question Posted / ravikumar2614

Answer Posted / ravikumar2614

Data flow like:
SRC-->SQ-->SEQ_GEN-->EXP-->AGGR-->FLTR-->TGT

create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND M_PORT-SEQ_PORT!=0"

If my approach is wrong correct me on ravi.infop@gmail.com

Is This Answer Correct ?    14 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is workflow manager?

1098

How can a transformation be made reusable?

1221

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

What are the settings that you use to configure the joiner transformation?

1096

Is it possible to define a single node as a Gateway node as well as worker node?

1176

What are the steps involved in the migration from older version to newer version of Informatica Server?

2150

What is a surrogate key?

1150

What is difference between a gateway node and worker node?

1196

How do you update the records with or without using update strategy?

1160

Briefly define reusable transformation?

1178

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2046

What is workflow? What are the components of workflow manager?

1230

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1311

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2180

What is informatica etl tool?

1053