Answer / reddy

parcistance cache is one of the cache which is in lookp t/r
It is used in multiple session runs.this improves the
performance.
If we wnat to run the same session more then one time then
we go for percistance cache.

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

What is decode in informatica?

0 Answers  

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

What if the source is a flat-file?

0 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

How would you copy the content of one repository to another repository?

0 Answers  

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---

explain about session partitions ?

1 Answers  

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---