Answer / Mukesh Singh Hyanki

Mapping Parameters in Informatica allow users to specify values that can be used across multiple transformations within a single mapping, while Mapping Variables are used to store temporary values during the execution of a transformation. Both help improve efficiency by reducing the need for hard-coded values and making it easier to manage complex data transformations.

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

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

1 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

In development project what is the process to follow for an etl developer from day1

1 Answers  

---

What you know about transaction control transformation?

1 Answers  

---

where to store informatica rejected data?

1 Answers  

---

Different circumstance which drives informatica server to expel records?

1 Answers  

---

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

What is the default join that source qualifier provides?

3 Answers   Informatica,

---

How to differentiate between the active and passive transformations?

1 Answers  

---