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 is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

Define Update Override?

1 Answers  

---

What is the difference between view and materialised view?

6 Answers  

---

How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---