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
- 6537 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
define galaxy repository in informatica
Implementation methodology
Can we create two repositories on same database instance in oracle?
Enlist some properties of sessions.
Which files are created during the session rums by informatics server?
Define filter transformation?
What are the different components of powercenter?
How can you define user defied event?
What is target load order?
expain about the tune parameters?
Explain what is informatica metadata and where is it stored?
What is transformation?
Explain incremental aggregation in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the way to execute pl/sql script using informatica mapping?
