Answer / srinu

A complex mapping generally will have the following
charectaristics
1.difficult requirement
2.More no.of transformation
3.having difficult business logics
4.may require combinatio of two or more methods combination

Answer / guest

SCD 2 is coplex mapping

Answer / shiv

1. Complex Bussiness Logic
2. More than 30 unconnected lookup.

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

Explain about Recovering sessions?

1 Answers  

---

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

What is an expression transformation?

0 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

Enlist the various types of transformations.

0 Answers  

---

what is target update override and when we use it?

2 Answers   TCS,

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---