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

What you know about transaction control transformation?

0 Answers  

Can you copy the batches?

3 Answers  

how can we use sorter transformation in joins?

5 Answers   IBM,

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

what is INFORMATICA TESTING process

0 Answers  

What is the difference between stop and abort in informatica

0 Answers   Informatica,

why we use stored procedure transformation?

4 Answers   IBM,

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

What do you understand by term role-playing dimension?

0 Answers