Answer / ysindhureddy77@gmail.com

1. SQL Override is to limit the number of incoming rows entering the mapping pipeline
Lookup Override is to limit the number of lookup rows to avoid the whole table scan by saving the lookup time & cache it uses.

2. Lookup Override uses "Order By" clause by default
SQL Override doesn't uses it & should provide in our query if we require it.

3. SQL Override can provide any kind of join by writing the query
Lookup Override provides only Non-Equi joins

4. Lookup Override gives only one record even if it finds multiple records for a single condition
SQL Override doesn’t do that.

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

---

What is incremental aggregation?

0 Answers  

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

how to use incremental load?

2 Answers   TCS,

---

What is a test load?

1 Answers  

---

what happens when a batch fails?

3 Answers  

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

what is the difference between stop and abort?

3 Answers   TCS,

---

In warehouses how many schemas are there?

0 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---