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
- 6378 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 |
What is hash partition?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
How to eliminate 1st and last rows from the source and load the inbetween rows.
What are different types of transformations available in informatica?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
what is the difference between stop and abort?
Different circumstance which drives informatica server to expel records?
Explain the features of connected and unconnected lookup.
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
How can you define a transformation? What are different types of transformations in Informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
Teradata 
