Answer / 9019

Sorter select distinct, aggregator group by columns

What is informatica etl tool?

0 Answers  

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

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 is casual dimension?

6 Answers   IBM,

---

Why do we use DSS database for OLAP tools?

2 Answers  

---

How can you complete unrcoverable sessions?

1 Answers  

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

What are ETL Tools?

0 Answers   Informatica,

---