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

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

Answer Posted / gurava reddy

Source-SQ-SEQ-FILTER-TARGET

1.Connect the sequence genarater(NEXTVAL) to filter in filter

IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)

2. Then connect the ports to destination(Target)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of decode in informatica?

1108


What is the use of code page?

1068


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2228


Enterprise data warehouse your projects phase by phase explain?

1907


What is flashback table ? Advance thanks

1922


Explain sql transformation in script mode examples in informatica

1109


What is the use of an aggregator cache file?

1181


What happens when a session fails and you click on recover?

1110


What is the benefit of partitioning a session?

1162


What are the types of schemas we have in data warehouse and what are the difference between them?

924


how to load rows into fact table in data warehouse

1162


What is a pre-defined event and user-defined event?

1025


Design time, run time. If you don't create parameter what will happen

1827


Write the unconnected lookup syntax and how to return more than one column.

1097


How to Create a folder using pmrep command?

1157