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
2
3
*
4
5
6
*
7
8
9

how to load records between two stars(*),

Answer Posted / lakshmi

Use Replacechr() in Expression T/r after Source Qualifier
and replace '*' with Space

Then In Filter T/r Use Filter condition as below
iif(isspaces(field,0,1))

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica metadata and where is it stored?

1044


What could be the possible resons of locks by user?

1144


Differentiate between a repository server and a powerhouse?

1186


What are the new features of Power Center 5.0?

1848


What is meant by target load plan?

1030


What is a difference between complete, stop and abort?

1125


What is transformation?

1159


What are the different types of olap? Give an example?

1098


What are the different clients of powercenter?

1117


Explain lookup transformation is active in informatica

1150


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2252


What are the types of caches in lookup?

1096


Explain constraint based loading in informatica

1157


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174