Answer / subhash

SELECT NO, NAME,
MAX(ADDRESS) AS ADDR1,
MIN(ADDRESS) AS ADDR2
FROM TABLE_NAME
GROUP BY (NO,NAME)

Answer / ravi

can we get it by implimenting scd3 please correct me

Answer / honey

I think this is the concept of scd type 3

Answer / satish

Use a dynamic lookup to check if the record exists,
If it is not then
Insert that record in No , Name and Address1
If it is then use that record to update the address 2 field always, this might be a case where the client wants to keep the first record and current record in the address 2 field

Answer / santosh

select no, name, max(decode(ronum,1,address1)) as address1,
max(decode(ronum,2,address1)) as address2 from (select
no,name,address1,row_number() over(partition by no order by
no) as ronum from model16) group by no, name

Answer / jz

select * from table_nme group by NO having count(*) > 1

or

Use Agg t/r group by on port 1

Define error Threshold?

1 Answers  

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

What is a joiner transformation?

0 Answers  

How do you do error handling in Informatica?

1 Answers  

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

permutations of mapplet

0 Answers   TCS,

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

What is meant by target load plan?

0 Answers  

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,