i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc
- 3 Answers
- 5220 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 |
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What are the mapings that we use for slowly changing dimension table?
What is exclusive and normal mode for repository services?
Where are the source flat files kept before running the session?
What is source qualifier transformation?
What are the different types of code pages available in informatica & how to implement it in your project?
What is the sequence generator transformation in informatica?
What is sorter transformation?
How many repositories can we create in Informatica?
how to load dimension table and fact table. plz tell me the steps.
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Teradata 
