Interested to Buy Any Domain ? << Click Here >> for more details...
I have table name in that I have
Rajesh
Reshika
Priya
I want the result Like only Starting with R
Rajesh
Reshika
Can someone help me to get these results and How?
- 3 Answers
- 6583 Views
- I also Faced
- E-Mail Answers
Answer Posted / vamshi ch
U can do by using the expression.
Use variable var1.
Var1= IIF(SUBSTR( NAME_FIELD, 1, 1 )=R,1,0)
In Filter use the condition to filter var1=1.
Only the names starts with R will come as output.
Another way:
In source qaulifier write a query to filter the records
which starts with name 'R'.
Select * from Table where name like 'R%'
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain the informatica workflow?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the static cache and dynamic cache in informatica?
How can informatica be used for an organization?
Enlist the advantages of informatica.
Why sorter is an active transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is InformaticaPowerCenter?
What is the use of source qualifier?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Differentiate between a repository server and a powerhouse?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
