Answer / suraj kedia

Look up t/r is used in a mapping to look up data in a
relational table,flat file,view or synonym.

The informatica server queries the look up source based on
the look up ports in the transformation.It compares look up
t/r port values to look up source column values based on the
look up condition.
Look up t/r is used to perform the below mentioned tasks:

1) To get a related value.
2) To perform a calculation.
3) To update SCD tables.

Explain transaction control transformation in informatica

0 Answers   Informatica,

---

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

What is the session task and command task?

0 Answers  

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---