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
- 6301 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
How to differentiate between the active and passive transformations?
How to recover sessions in concurrent batches?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What are the different options available for update strategy?
What is the procedure to load the fact table.Give in detail?
What is a parameter When and where do you them when does the value will be created
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
how to duplicates from expression transformation without using sorter before that
In informatics server which files are created during the session rums?
Teradata 
