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

Explain the different dimensions.

974


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1064


How union transformation is used?

1016


Differentiate between joiner and lookup transformation?

1109


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.

1997


Enlist the tasks for which source qualifier transformation is used.

1050


What is the procedure for creating independent data marts from informatica 7.1?

1068


What is meant by pre and post session shell command?

1167


Which development components of informatica have the highest usage?

1065


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8229


Can informatica load heterogeneous targets from heterogeneous sources?

1192


How to go to the older version for a mapping?

1109


Explain the shared cache and re-cache?

1127


What is deployment group?

1223


What are the advantages of using informatica as an etl tool over teradata?

1029