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)

Answer / sai

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

Answer / asjad

trim(Col_Nm,'0',L)

Answer / abhinaw prakash

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

What are the basic needs to join two sources in a source qualifier?

3 Answers  

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---

What are the different types of repositories created using informatica?

1 Answers  

---

What are the different tools in workflow manager?

1 Answers  

---

What are the different types of olap? Give an example?

1 Answers  

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1 Answers  

---

diffrence between command task and control task

1 Answers   iNautix,

---