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.

Explain what transformation and how many are there in informatica?

0 Answers  

---

What is DR strategy for Informatica project?

0 Answers  

---

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

---

What are the uses of etl tools?

0 Answers  

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

Define enterprise data warehousing?

0 Answers  

---

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---