when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

How does the aggregator transformation handle null values?

0 Answers  

---

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

---

What is deployment group?

0 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Explain the use of aggregator cache file?

0 Answers  

---

What is the session task and command task?

0 Answers  

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---