Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 6697 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is sequence generator transformation in informatica?
Explain the tuning lookup transformation - informatica
What are the components of Informatica? And what is the purpose of each?
Parameter and variable differences
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the tuning techniques you applied during your last project
what is the hint? how to use it to reduce the query processing in program?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the uses of etl tools?
How to update or delete the rows in a target, which do not have key fields?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are connected or unconnected transformations?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is a shortcut and copy in Informatica and how two are different with each other?
