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

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

What is primary and backup node?

0 Answers  

---

What is joiner change?

0 Answers  

---

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

---

Without source how to insert record to target?

6 Answers  

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

How union transformation is active ?

2 Answers   Puma,

---

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,

---

What is meant by target load plan?

0 Answers  

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

Can you copy the batches?

3 Answers  

---

What are active and passive transformations?

0 Answers   Informatica,

---