Interested to Buy Any Domain ? << Click Here >> for more details...
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
- 3 Answers
- 7965 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi,
You can achieve it easily in expression transformation by making an extra out port where you just need to specify
substr('ankit42',1,instr('ankit42','4')-1) logic.
but keep in mind that all of your source data must contains 42 as defined in your problem.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
Explain the code page compatibility?
How we can create indexes after completing the loan process?
To import the flat file definition into the designer where should the flat file be placed?
What is the use of code page?
What is the difference between source qualifier transformations source filter to filter transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can we delete duplicate rows from flat files?
How do you take back up of repository?
Design time, run time. If you don't create parameter what will happen
Explain what is informatica metadata and where is it stored?
Why union transformation is an active transformation?
how to load rows into fact table in data warehouse
What is the difference between informatica 7.0 and 8.0?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
