Answer Posted / babu

Hi,
As per my knowledje,i find below method for u r query.

select * from tab where col1 between 'A' and 'Z' or col1
between 'a' and 'z' or col1 between '0' and '9'

please let me know,if u have any concerns.

Babu

What are the new features of informatica 9.x in developer level?

936

---

How to update or delete the rows in a target, which do not have key fields?

1115

---

expain about the tune parameters?

2336

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2312

---

What is a difference between complete, stop and abort?

1030

---

How to Create a folder using pmrep command?

1102

---

I have a flat file, want to reverse the contents of the flat file

1064

---

explain one complex mapping with logic? sales project?

6591

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1441

---

Explain in detail about scd type 1 through mapping.

1296

---

generate date / time dimension in informatica

1066

---

Explain joiner transformation in informatica

1072

---

Explain sessions. Explain how batches are used to combine executions?

952

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2178

---

Explain pmcmd command usage in informatica

1064

---