Answer / anil

1.Degenerated
2.Confirmed
3.Junk
4.SCD's

Answer / chowdary

anil correct

Answer / yash

1. Uni Dimension
2. Junk Dimension
3. Hanging Dimension
4. Confirmed Dimension
5. SCD (A property of Dimension)

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

Can we update the data in flat file using update strategy?

3 Answers  

---

Different circumstance which drives informatica server to expel records?

0 Answers  

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

Parameter and variable differences

0 Answers  

---

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

What is informatica? Why do we need it?

0 Answers  

---

When to use normalization transformation other than cobol source?

2 Answers  

---

What are pre and post-session shell commands?

0 Answers  

---