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.

Whats there in global repository

0 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

without using emailtask how will send a mail from informatica?

3 Answers  

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---

what is the flat file partition and where have to specify it

1 Answers   TCS,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

how to we create datamart?

2 Answers   HSBC,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---