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
- 6536 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / babu
Hi,
IF U R SOURCE IS FLAT FILE,
U CAN WRITE A FILTER CONDITION IS SUBSTR(COL1,1,1)='R'
THEN U GET ONLY COL1 STARTING VALUE IS R.
ELSE U R SOURCE IS RELATIONAL
WRITE SQL OVRRIDE IN SQ T/R
AS SELECT * FROM TAB_NAME WHERE COL1 LIKE 'R%'
THEN U GET ONLY COL1 STARTING WITH R DATA.
IF ANY THING IS WRONG CORRECT ME.
THANKS,
BABU
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
SELECT * FROM TABLE NAME LIKE'R%'
OR U CAN USE SUBSTRING
SUBSTRING(RAJESH,1,1)
| Is This Answer Correct ? | 1 Yes | 1 No |
which one is better either active or passive transformation in informatica
What is parallel processing in informatica?
what are the row and column separations in Flat Files
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How can informatica be used for an organization?
create a mapping to retrieve the employees who are getting salary greater than average salary?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How we can use union transformation?
Parameter and variable differences
how to we create datamart?
Teradata 
