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.

How can you access the remote source into your session?

1 Answers  

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

---

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

---

how many types of dimensions are available in informatica?

0 Answers  

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

---

What are the different tools in workflow manager?

1 Answers  

---

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

---