Answer / megha bagaria

Hi Swetha,

Data Quality is when you verify your data and identify if the data present in the warehouse is efficient and error free. The data present in each column should have the meaning full information like it should not have null data, it should not have garbage data, complete correct data must be transformed to the target data, if all the data types are correct as per the requirement, etc.
Asking for Informatica transformations means you want to know how source target tranformations to be implemented in informatica?

Thanks and Best regards,
------------------------------------------------------------
Megha Bagaria | InfoCepts Technologies Pvt Ltd
------------------------------------------------------------

Answer / srinu

Data wili have Special characters,Symbols,Nulls,Zeros,,,
You need Cure the Data using Default values,Null
updates,,,like many things r there,,
In Inf trans Avoid the nulls,Correct DataType with
Length,Unique data,,,,like,,many ways u can cure the data.

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

---

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

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,

---

What is synonym?

2 Answers   Patni,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

How is Data Models Used in Practice?

1 Answers  

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---