Answer Posted / avru.bal

we can join the 2 flat files by using filerepsitory..save
both files in one directory gve the path name c:\.txt and
provide default type=oracle then apply,
in session properties provide
source file directory:c:/txt
source file type:indirect
provide target connection..so that we can join the both
files without using joiner n lookup

What is native users?

1168

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1110

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

---

What are the advantages of using informatica as an etl tool over teradata?

1022

---

How to use pmcmd utility command?

1034

---

wat are deployement groups in informatica, how it will be used for developers

1719

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What does refresh system mean, and what are its distinctive choice?

1183

---

what are the deliverables?in your project?

2152

---

what is the complex transformation you used in informatica

2588

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

---

What is different between the data warehouse and data mart?

1067

---

What do you mean by channel change?

1048

---

What is workflow monitor?

1062

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1076

---