Answer / venubyna1

Lookup is better as compare to join
bcoz joiner does not supports to inequality but look
supports to inequality
and both r does not support OR condition

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

What is the difference between view and materialised view?

6 Answers  

---

What are the reusable transforamtions?

1 Answers  

---

What is meta data and system catalog?

2 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---