Interested to Buy Any Domain ? << Click Here >> for more details...
i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
- 3 Answers
- 5701 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
SQ - Exp - Target
In exp transformation
newport1 - SUBSTR(column1,1,3)
newport2 - LTRIM(RTRIM(column1))
newport3 - REPLACECHR(1,newport2,'101','')
newport4 - newport1 || ' ' || newport3
pass newport4 to target
anyone pls confirm if it is wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / dilip ingole
using SQL
SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(TRANSLATE('101 a 101 b 101 c','1234567890',' '),' ','') DATA FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
In joiner, how to load Master table in Target?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is dimensional table?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Suppose we do not group by on any ports of the aggregator what will be the output?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
How can we use batches?
why we use datawarehouse
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Teradata 
