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.

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

What is degenerated dimention table?

7 Answers   Patni,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,

---

Explain lookup transformation source types in informatica

0 Answers   Informatica,

---

How do you convert single row from source into three rows into target?

0 Answers  

---

scd methodology?

2 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

---