Answer / mln

The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

what is confirmed dimension?

6 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

---

What are the restrictions of union transformation?

0 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

Can you copy the session to a different folder or repository?

2 Answers  

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---