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

dimension object created in oracle can be imported in designer?how?

0 Answers  

---

Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

what is the difference between cubes and package in cognos

0 Answers   Cognizant,

---

what is the indicator file and where it is used?

1 Answers  

---

Can u access a repository created in previous version of Informatica?

0 Answers  

---

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  

---

what are the concerns of OLTP and DSS systems?

0 Answers  

---

Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  

---

Difference between flat files and relational sources?

0 Answers   Satyam,

---

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,

---

How can we use external procedural logic in informatica?

0 Answers  

---