How do you remove duplicate records in informatica? And how many ways are there to do it?

1167

What is source qualifier transformation in informatica?

1011

How can a transformation be made reusable?

1168

What is a shortcut and copy in Informatica and how two are different with each other?

1197

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

What is the use of code page?

1094

What happens when a session fails and you click on recover?

1120

What is union transformation?

965

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6178

What are the types of caches in lookup?

1049

How can we improve session performance in aggregator transformation?

1117

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6490

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

1206

Why sorter is an active transformation?

1192

How we can create indexes after completing the loan process?

1211