Answer / sukanta

Lookup-

Let suppose you have empno in your source table but the
empno,address,name etc are stored in a lookup table and you
want all detail of employee will be go to target,then look
up is better option.

Lookup is passive transformation and support join on lookup
table basis of src.empno=lkp.empno(+).that means if in the
lookup table not have the source coming empno then it will
return null value for lookup empno.

so let suppose the lookup table is the target table in your
mapping,then you can find out the target table exists the
source record or not.

Joiner

If you want, the join condition satisfied,then the
satisfied all rows should go for next then join condition is
mandatory.Lookup can't do that.

Previous is posted by me.

Regards

Sukanta

Answer / guest

Lookup-

Let suppose you have empno in your source table but the
empno,address,name etc are stored in a lookup table and you
want all detail of employee will be go to target,then look
up is better option.

Lookup is passive transformation and support join on lookup
table basis of src.empno=lkp.empno(+).that means if in the
lookup table not have the source coming empno then it will
return null value for lookup empno.

so let suppose the lookup table is the target table in your
mapping,then you can find out the target table exists the
source record or not.

Joiner

If you want, the join condition satisfied,then the
satisfied all rows should go for next then join condition is
mandatory.Lookup can't do that.

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

what is mean by grouping of condition column in lookup transformation?

1 Answers  

---

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 are the deliverables?in your project?

0 Answers   DELL,

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

In dimension and fact table? which one holds big data?

2 Answers  

---

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

---

why we use datawarehouse

0 Answers   HCL,

---

Define mapplet?

0 Answers  

---