Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7106 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sree
in exp t/r u can write ltrim(id,'0')
iam giving just an idea
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How do you set a varible in incremental aggregation
Write the prerequisite tasks to achieve the session partition?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the differences between a connected lookup and unconnected lookup?
What all join we can perform in LOOKUP transformation?
Differentiate between a repository server and a powerhouse?
What is the function of aggregator transformation?
Can u generate reports in Informatica?
What are the tuning techniques you applied during your last project
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain direct and indirect flat file loading (source file type) - informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the measure objects?
Plz can any one say me how to get the informatica certification materials and dumps
