Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc

Question Posted / santhosh

Answers were Sorted based on User's Feedback



i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc..

Answer / 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

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc..

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

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc..

Answer / mahesh

using Aggregator ......

create group by on col1

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

What are the types of metadata that stores in repository?

2 Answers  

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

What is mapping debugger?

0 Answers  

where to select code page option?

2 Answers   TCS,

What are Business Components in Informatica?

1 Answers  

What is sq transformation?

0 Answers  

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

For more Informatica Interview Questions Click Here
Categories