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

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

What is a candidate key?

7 Answers   CTS,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

What is meant by target load plan?

0 Answers  

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

What are the connected or unconnected transforamations?

2 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,