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...

I am having source
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
Target
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
If a new record coming from source from same location it should directly go to specified location in target at begining
EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

Answer Posted / babu

what about ENO AND ENAME VALUES,
its should be old values or new values?

please give your output data sample exactly what you need.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1154


Explain the types of transformations?

1068


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910


What do you mean by channel change?

1047


How can you differentiate between powercenter and power map?

1089


What is a repository? And how to add it in an informatica client?

1149


What is data caches/ index caches?

1105


What is difference between a gateway node and worker node?

1138


What is the meaning of up gradation of repository?

1989


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079


What is repository manager?

989


What is the maplet?

1120


What is target load order?

1246


What is the function of look up transformation?

1123


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125