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
- 5462 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
What is a pre-defined event and user-defined event?
Under which circumstances, informatica server creates reject files?
Explain lookup transformation is active in informatica
How to elaborate powercenter integration service?
What are the reusable transformations?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How an expression transformation differs from aggregator transformation?
whats the logic to load the lower level of granularity of data to fact table.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the transformations that are not supported in mapplet?
Tell me about Propagate functions in informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is song in infrmatica...?
What is the need of an ETL tool?
