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%'

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

Answer / guest

SELECT * FROM TABLE NAME LIKE'R%'
OR U CAN USE SUBSTRING
SUBSTRING(RAJESH,1,1)

What is the difference b/w natural key and surrogate key

1 Answers  

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

What is source qualifier?

6 Answers   SDS,

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

why we use source qualifier transformation?

16 Answers   Accenture,

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---