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)

Mention few power centre client applications with their basic purpose?

0 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

How is Data Models Used in Practice?

1 Answers  

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

How to extract sap data using informatica?

0 Answers  

---

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---