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
- 6429 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
Can we create a Integration service without a Repository service and vice versa?
How are the sources and targets definitions imported in informatica designer?
What is an expression transformation in informatica?
What are the components of Informatica? And what is the purpose of each?
What is an active transformation?
According to his methodology what all you need before you build a datawarehouse
What are the differences between source qualifier and joiner transformation?
What are the uses of etl tools?
Tell me about MD5 functions in informatica
What is an Integration service in Informatica?
Explain joiner transformation in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How does a sorter cache works?
