Answer / pooja ahmed

1. you can you use sorter transformation .... in that you
select distinct option

2. use agg trans .... in that go for group by

usi8ng above metyhod you can remove duplicate rec...

Answer / bsgsr

duplicate records can be eliminated the following ways:

1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor

Answer / bhagya

1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation

Answer / raghav

with out distinct we can do it in 3 possible ways.

1. Using Group by function which will act like a distinct in
TD13.0 database

2. using SET table concept, like first we create the multi
set table and insert the duplicate rows into them and then
create the set table and use the insertselcet concept, in
this case only distinct rows will be inserted.

3. use rowid, derived table or sub query concept then we can
do this

what is the meaning of upgradation of Repository?

0 Answers   IBM,

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

---

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

---

How etl testing is different from database testing?

0 Answers  

---

Explain the difference between etl tool and olap tools?

0 Answers  

---

what are the cubes developed in a sap bw project and what is the requirement for developing it?

0 Answers   Maersk,

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

---

What is etl process?

0 Answers  

---

Difference between flat files and relational sources?

0 Answers   Satyam,

---

What is ROWID explain ?

2 Answers   Wipro,

---

Eliminating of duplicate records without using dynamic lookups

3 Answers  

---