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 / satish

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the benefit of partitioning a session?

1101

How to configure mapping in informatica?

1117

How many ways a relational source definition can be updated and what are they?

951

Write the prerequisite tasks to achieve the session partition?

1069

How to Create a folder using pmrep command?

1102

Is there any target staging area in informatica not staging area

2505

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10629

what is the hint? how to use it to reduce the query processing in program?

7624

Different sorts of metadata that stores in the storage facility?

947

What is data movement mode in Informatica and difference between them?

1056

How to open an older version of an object in the workspace?

1125

whats the logic to load the lower level of granularity of data to fact table.

2205

Define the various join types of joiner transformation?

940

How to generate sequence numbers using expression transformation?

1025

Which development components of informatica have the highest usage?

983