Answer / rkumar.etl

Unit testing in Informatica performed using ...

1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.

2)column to column mapping to make sure the result passing
to columns are correct.

3)data type mismatch or matched.

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

What is mapplet and a reusable transformation?

2 Answers  

---

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

---

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

What is A complex mapping?

3 Answers   TCS,

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

In a sequential batch can u run the session if previous session fails?

3 Answers  

---

How mapping parameter and variable works

1 Answers  

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

---

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

---