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
- 6423 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
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the types of lookup transformation?
Enlist the advantages of informatica.
Explain your project of banking domian.
In informatics server which files are created during the session rums?
What are the performance considerations when working with aggregator transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
without table how to come first record only in oracle?
What is parallel processing in informatica?
What is the format of informatica objects in a repository?
What is olap (on-line analytical processing?
Which transformation should we use to normalise the COBOL and relational sources?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
where to store informatica rejected data?
