Answer / rahul

Collect performance data this option is available at session level. used to identify the flow of records between transformations.


http://netezzamigration.blogspot.com/2014/10/what-is-collect-performance-data-in.html

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

What is a filter transformation?

0 Answers  

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

what is the flow?

1 Answers  

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

---