Answer / murthy

generally lookup is used to search for a record.in realtime
mainly people use this to fetch the key values doing a
lookup on the other table.

Answer / kaki

Look up transformation is used for looking up a value from
OLAP table within a mapping before populating it. For
example, I have empid and I want to get emp name to use in
the next transformation, I would search for it in a look up
table which has the emp name by giving input as emp id.

How can we use external procedural logic in informatica?

0 Answers  

---

Is apache nifi an etl tool?

0 Answers  

---

Explain do we need an etl tool?

0 Answers  

---

What are your responsibilities as an etl tester?

0 Answers  

---

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

0 Answers  

---

without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers  

---

what is meant by drill through?(Mascot)

1 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,

---

what is session partitioning?

0 Answers  

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

what make u disappointmnets in u r career

0 Answers   Infosys,

---