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

My source table look like
ID Name Location Salary
0000001 ran tpty 1000
0000002 ram DELHI 2000
hju-hji raj hyd 1000

my target table should be
ID Name Location Salary
1 ran tpty 1000
2 ram DELHI 2000
hju-hji raj hyd 1000

Question Posted / charangiri.p

Answers were Sorted based on User's Feedback



My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ..

Answer / sree

in exp t/r u can write ltrim(id,'0')

iam giving just an idea

Is This Answer Correct ?    12 Yes 2 No

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ..

Answer / xyz

in expression t/r use replace(id,'000000','')

Is This Answer Correct ?    5 Yes 4 No

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ..

Answer / rakesh

Hi,

Use trim(leading '0' from '00001') option
Please let me know if i am wrong

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

What is the benefit of partitioning a session?

0 Answers  

How do we call shell scripts from informatica?

0 Answers  

Target increases every day even though no new record was inserted

0 Answers   Accenture,

How to extract the informatica rejected data?

0 Answers  

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

Do you find any difficulty while working with flat files as source and target?

0 Answers  

What are the modules in Power Center

0 Answers  

What are the tasks that source qualifier performs?

1 Answers  

For more Informatica Interview Questions Click Here
Categories