Answer Posted / nagaraju bhatraju

1.)
we can distinguish between unique and duplicate records in
informatica by using forward reference technique ,
in the sense , we can store the previous rec key value in
Variable_Port and can be compared with the previous rec key
value , but Data has to be come in sorted order on that key
column , for that we should use sorter transformation.

once if you find the duplicate rec by comparing , you can
flag that rec as dulicate and you can divert it to other
target.

2.) with out using sorter

in order to collect only unique records for flat file ,
just use aggregator before exp transformation, and check
group by on the key column where you are expecting
duplicate records. so you will get only unique records and
duplicate records will be eliminated.

What is meant by query override?

1112

---

Explain sessions?

1132

---

What is main use of mapplet?

1174

---

Can you generate sequence numbers without using the sequence generator transformation?

1156

---

What is confirmed fact in dataware housing?

7097

---

What is the surrogate key?

1356

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1641

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248

---

What is the fact table?

1128

---

How many number of sessions can one group in batches?

1215

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2293

---

What are different types of transformations available in informatica?

1055

---

What is the format of informatica objects in a repository?

1073

---

How can one identify whether mapping is correct or not without connecting session?

1491

---

Have you worked with/created Parameter file

1708

---