Answer / avinash

Expression tranformation is used in data cleansing.

If ur target table consist of not null column and source
table consisting null columns so assign some value in
expression tr.
and then pass data to target.

Answer / shashiall

Source Qualifier Transformation and Expression
Transformation are used for Data cleansing.
Data types ,Date formats,null ..not null
constraints ..these r main things considered in the data
cleansing.

Answer / d.chandrasekar

Hi Friends,

My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

What is query panel?

1 Answers  

---

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

What are the connected or unconnected transforamations?

2 Answers  

---

What is a poling?

2 Answers  

---

What is A cache?

2 Answers  

---

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

What is workflow? What are the components of workflow manager?

0 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---