Answer / babulcity

Natural Key is key attribute column of an entity with
distinct values i.e without duplicates/NULL.
Eg: For natural Key we can define constraint like PK,FK

Surrogate Key is an substitute key which is not a part of
attribute of entity & is unique but it can be used to act as
PK,FK when you cannot use the Natural key.

What is pmcmd command?

0 Answers  

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

---

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,

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

What is status code in informatica?

0 Answers  

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

how to we create datamart?

2 Answers   HSBC,

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

What is the fact table?

0 Answers  

---