Answer / naveen

Hi

Please refer below mention URL, you will get the complete information about SCD.
http://informaticatutorials-naveen.blogspot.in/2011/04/scd-type-1.html#axzz1qxbPamNm

Regards,
Naveen

Why do we need informatica?

0 Answers  

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

What is a code page?

0 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

What is sequence generator transformation in informatica?

0 Answers  

---

How many transformations can be used in mapplets.

0 Answers  

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

What is meant by incremental aggregation?

0 Answers  

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---