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
- 6693 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
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Global and Local shortcuts. Advantages.
What all join we can perform in LOOKUP transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a predefined event?
What is the benefit of session partitioning?
What are the features of complex mapping?
How to create a non-reusable instance of reusable transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Please let me know how to make Data masking in informatica..
What are different types of transformations available in informatica?
Informatica settings are available in which file?
What is informatica?
Explain pushdown optimization and types in informatica
