Answer / rajendra

Hi everybody

A Dimension which is shared bu multiple fact Tables
is known as Conformed Dimension.

Answer / ramesh

fact is a measure and methods of data is confirmed in
datawarehousing

How to recover sessions in concurrent batches?

1 Answers  

---

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

---

Clarify the aggregator change?

0 Answers  

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

What do you mean by blocking transformation?

0 Answers  

---

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---