Answer / rakesh

Using FileList concept.
i.e; keep all flat file paths in a text file and mention
this file name in source file name of session. and mention
the source file type as INDIRECT.

why we use materialized view over view?

1 Answers   Zensar,

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

What is rank transform?

0 Answers  

---

can you avoid static cache in the lookup transformation? I mean can you

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  

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---