Answer / sbvp

1.FLAG
2.versioning
3.date range
there is three types to implement scd2.

Answer / pune.rohitsharma

my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2

Answer / kumar raja kotakonda

1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING

Answer / radhakrishnansk

write pl sql scripts

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

How to open an older version of an object in the workspace?

0 Answers  

---

How do we call shell scripts from informatica?

0 Answers  

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

disable caching in a lookup transformation?

1 Answers  

---