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

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

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

13 Answers   BirlaSoft, IBM,

---

scd methodology?

2 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

---

What are active transformations.

0 Answers  

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

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

0 Answers  

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

How are indexes created after completing the load process?

0 Answers  

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

8.what is mapplet ?give example?

2 Answers  

---