Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi,
In source I have records like this
No name address
10 manoj mum
10 manoj dilhi
20 kumar usa
20 kumar Tokyo
I want records in target like shown below
No name addr1 addr2
10 manoj mum dilhi
20 kumar usa Tokyo

If it is reverse we can do this by using Normalizer
transformation by setting occurance as 2.
Somebody will say use denoralization technique. But as of my
knowledge I couldn’t find any denormalization technique. Is
there any concept like that?
I tryid this seriously but I could find any idea to
implement this.
Can any one please help me ?
Advance Thanks

Question Posted / c manojkumar

Answers were Sorted based on User's Feedback



Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar u..

Answer / subhash

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

Is This Answer Correct ?    2 Yes 0 No

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar u..

Answer / ravi

can we get it by implimenting scd3 please correct me

Is This Answer Correct ?    2 Yes 1 No

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar u..

Answer / honey

I think this is the concept of scd type 3

Is This Answer Correct ?    2 Yes 1 No

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar u..

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

Is This Answer Correct ?    1 Yes 0 No

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar u..

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

Is This Answer Correct ?    1 Yes 0 No

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar u..

Answer / jz

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

or

Use Agg t/r group by on port 1

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

how can we calculate fact table size?

1 Answers  

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

How many ways are there to create ports?

0 Answers   Informatica,

What is difference between a gateway node and worker node?

0 Answers  

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

Why we use partitioning the session in informatica?

2 Answers  

For more Informatica Interview Questions Click Here
Categories