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
- 6691 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 |
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Why we use lookup transformations?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
What are the data movement modes in informatcia?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What are the new features of informatica 9.x at the developer level?
Difference between task flow and linear task flow
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
What are the measure objects?
What is aggregate awareness?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Teradata 
