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.

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

What are the different components of powercenter?

0 Answers  

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

What is joiner transformation?

0 Answers  

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

---

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  

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---