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?
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 |
Can yoU use the maping parameters or variables created in one maping into another maping?
What is status code?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
what are presession,postsession success and postsession failure commands ?
What is joiner change?
What is confirmed fact in dataware housing?
in realtime which situations u can use unconnected lookup transformation
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
how to get the first row without using rank t/r?
What is A complex mapping?
WAT IS TEXT LOAD?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain