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
- 6521 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 is a repository manager?
How you can differentiate between connected lookup and unconnected lookup?
What are Dimensional table?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is data transformation manager process?
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
What is the need for an etl tool?
What does refresh system mean, and what are its distinctive choice?
What if the source is a flat-file?
How do you promote a non-reusable transformation to reusable transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain the code page compatibility?
Describe data concatenation?
How we can use union transformation?
What is meant by target load plan?
