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

how do use session mapping parameters ?(in which transformation)

0 Answers  

---

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,

---

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,

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,

---

what are the different forms of normalization?

2 Answers  

---

if i have a query as flat file how can we load data to target table

0 Answers   Tech Mahindra,

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

0 Answers   L&T,

---

Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,

---

how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

2 Answers   TCS,

---

what are the different Reporting and ETL tools available in the market?

3 Answers  

---

Explain and compare etl & manual development?

0 Answers  

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  

---