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

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

3 Answers
6855 Views
TCS, I also Faced
E-Mail Answers

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

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers

how will you get 21 to 30 record from 50 records?

6 Answers

difference between repository database and repository service?

0 Answers

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers Oracle,

what is incremental data aggregation?

3 Answers IBM,

What is union transformation?

0 Answers

what is hash table in informatica?

1 Answers Zensar,

What are Dimensions and various types of Dimensions?

3 Answers PayPal, TCS,

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers IBM,

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers IBM,

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers HCL,

For more Informatica Interview Questions Click Here