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

i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.

Answer Posted / koti

take sequence generator to target and take expr
transformation to source qualifiew transf. and one new
port. and define that port as iif(sno=1 or 5,'true','false')
connect these to target.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7114


Explain what are the different versions of informatica?

1031


Why filter transformation is an active one?

929


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1033


Is there any target staging area in informatica not staging area

2507


What is mapping debugger?

944


Define the various join types of joiner transformation?

941


What is joiner transformation in informatica?

993


Differentiate between a repository server and a powerhouse?

1045


Explain lookup transformation in informatica

1004


What do you mean by channel change?

965


Do you find any difficulty while working with flat files as source and target?

1051


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3812


How do you remove duplicate records in informatica? And how many ways are there to do it?

1110


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

1058