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

Explain target update override in informatica

1124

---

Explain Dataware house architecture .how data flow from intial to end?

2581

---

Tell me about Propagate functions in informatica

920

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2192

---

Slowly changing dimensions, types and where will you use them

1713

---

what is diff b/t sorter t/r and agg have the option sorter property...

2171

---

What is the Rank index port in Rank transformation?

1055

---

draw informatica architecture 8.6 ?

3871

---

Explain constraint based loading in informatica

1093

---

What is aggregate cache in aggregator transformation?

1141

---

How to implement security measures using repository manager?

1177

---

How would you join a node to the already existing domain?

1128

---

How do you load only null records into target? Explain through mapping flow.

2017

---

How many numbers of sessions can one group in batches?

1064

---

How to elaborate powercenter integration service?

1131

---