Interested to Buy Any Domain ? << Click Here >> for more details...
replace multiple spaces with single space.
- 3 Answers
- 6526 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pushpendra
replacechr function can use.
replacechr(0,Column_Name,' ','')
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / xx
Its always better to use reg_replace check the below link
https://etltechsolutions.wordpress.com/category/informatica/
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / kartik
Hops I ound Trip Time robe1
to
Hops I ound Trip Time robe1
| Is This Answer Correct ? | 0 Yes | 1 No |
How can informatica be used for an organization?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain lookup transformation in informatica
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Mention a few design and development best practices for informatica?
differences between service based and product based?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Write the advantages of partitioning a session?
Teradata 
