Answer / cuckoo sreedhar

Lookup on flat file is possible.
Union Transformation is present.
Version Control.
LDAP Authentication.
supporting of 64mb architecture.

Answer / sarath

1)We can use flat file as a target
2)we can use flat file as a lookup
3)Mainly union t/r is introuduced in 7.1
4)Data profiling and versioning
5)Propagate attributes
6)we can do partiotions upto 64

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

Where do we use mapping variables in informatica?

0 Answers  

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

How can we create index after completion of load process?

0 Answers  

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---