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 reusable transformation?

0 Answers  

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

how to declare array in plsql?

1 Answers  

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

From where we can start or use pmcmd?

3 Answers  

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

What is facttable granularity?

2 Answers  

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

what is difference between COM & DCOM?

1 Answers   Satyam,

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---