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

how can you load data into target table without leading zeor's

Question Posted / charangiri.p

Answers were Sorted based on User's Feedback



how can you load data into target table without leading zeor's..

Answer / srini

By using the Trim function we can able to Remove the
leading Zero's in a value and we can load it in to target.
Function : trim(Col_Nm,'0',L)

Is This Answer Correct ?    12 Yes 2 No

how can you load data into target table without leading zeor's..

Answer / sai

Use Exp transformation and use function
Ltrim(col_name,'0')

Is This Answer Correct ?    6 Yes 0 No

how can you load data into target table without leading zeor's..

Answer / asjad

trim(Col_Nm,'0',L)

Is This Answer Correct ?    2 Yes 4 No

how can you load data into target table without leading zeor's..

Answer / abhinaw prakash

We can use Replace function as well to remove the zeroes
before loading the data into the target

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Informatica Interview Questions

Write the different tools in the workflow manager?

0 Answers  

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

What is the difference between informatica 7.0 and 8.0?

0 Answers  

where is the reject loader .

1 Answers  

what is scd?

6 Answers  

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

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

0 Answers  

For more Informatica Interview Questions Click Here
Categories