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

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

How to create the source and target database connections in server manager?

0 Answers   Informatica,

How will u pas the data with out debugger?

4 Answers  

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

What is workflow manager?

0 Answers  

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

How will you convert rows into columns or columns into rows

1 Answers  

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

without update strategy how to insert &update?

1 Answers   DELL,

when informatica 8 series released ?

1 Answers   IBM,