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

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2078

---

What is expression transformation?

1035

---

What is the need for an etl tool?

1010

---

What is a mapplet/worklet in informatica?

1120

---

How to generate sequence numbers without using the sequence generator transformation?

1113

---

What is event and what are the tasks related to it?

1054

---

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

1083

---

How we can create indexes after completing the loan process?

1142

---

What is union transformation?

907

---

What is an expression transformation in informatica?

963

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1033

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1172

---

What is update strategy transform?

1015

---

how to load rows into fact table in data warehouse

1115

---

In how many ways we can create ports?

1067

---