Interested to Buy Any Domain ? << Click Here >> for more details...
source table have single column single record having with
single space.
load that source record into trg . trgt having two columns
and the
SOURCE TABLE LIKE
COL1
BHANU PRASAD
TRGT TABLE
COL1 COL2
IN THAT LOAD THE RECORD IN THE trgt table LIKE
COL1 COL2
BHANU PRASAD
HOW ? TELL ME PLZ
- 2 Answers
- 6371 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suraj kedia
Let our source table name is "Name",which is having COL1 and
data in it is BHANU PRASAD (For easier understanding instead
of space between bhanu and prasad,lets take a underscore
i.e. BHANU_PRASAD.
Source ----> Exp t/r ----> target
In the exp t/r take "name" as an input port only and create
2 out put ports as COL1 and COL2.
In COL1 give condition
substr(Name,1,instr(Name,'_',1)-1)
In COL2 give condition
substr(Name,instr(Name,'_',1)+1)
now connect COL1 port form exp to COL1 port in tgt and same
for COL2, than the out put in the target table will be as below:
COL1 COL2
BHANU PRASAD
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What if the source is a flat-file?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What can we do to improve the performance of informatica aggregator transformation?
What is dimensional table?
Does an informatica transformation support only aggregate expressions?
Explain load alternative records / rows into multiple targets - informatica
What is an unconnected transformation?
What is the way to execute pl/sql script using informatica mapping?
How to use procedural logic inside infromatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
