Answer / lajpat kurdiya

SELECT SUBSTR('AMAR',LEVEL,1) AS Name
FROM DUAL
CONNECT BY LEVEL<= LENGTH('AMAR');

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  

---

flat filevalidation in informatica

0 Answers   Hewitt,

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  

---

what are business components in Informatica?

2 Answers  

---

Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,

---

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

Is apache nifi an etl tool?

0 Answers  

---

working of line item dimension......pls,tell overall flow

1 Answers  

---

what are the different forms of normalization?

2 Answers  

---

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,

---

What is data modeling and data mining?

0 Answers  

---

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  

---