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
- 5803 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / vidhyakarthik
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 |
Post New Answer View All Answers
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is exclusive and normal mode for repository services?
What is meant by query override?
r u done any partitions in ur project?
Explain in detail about scd type 1 through mapping.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Describe expression transformation?
What is xml source qualifier transformation in informatica?
What does reusable transformation mean?
What is Cognos script editor?
What is union transformation in informatica?
Separate from a database, an information bazaar, and an information stockroom?
How to create the source and target database connections in server manager?
How many ways a relational source definition can be updated and what are they?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
