Answer / rayudu

can you precisely tell me your requirement becoz we have
multiple ways to pivot the data

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

What is dimensional table?

0 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

what is the flow?

1 Answers  

---

What do think which one is the better joiner or look up?

1 Answers  

---

How do you load only null records into target?

1 Answers  

---

tell me the push down optimization

2 Answers   Wipro,

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

What are pre and post-session shell commands?

1 Answers  

---