Answer / sri

Lookup is a transformation in Informatica which is mainly
used for obtaining the "Key" values from the dimensions.
Lookup can be connected or unconnected. If it is
unconnected then it can be used as a function but it can
return only one value.
Where as connected lookup return more than one value.
Lookup contains:
1. <Input Column/Value>
2. <Output Column(s)>
3. <Condition>

Answer / guest

look up compares the source to target.it update and insert
the new rows to the target.

the default transformation for look up is source qualifier

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

---

Name the different lookup cache(s)?

0 Answers  

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---