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

suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how

Question Posted / shivaleela

Answers were Sorted based on User's Feedback



suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / leo gilbert

Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1

Is This Answer Correct ?    9 Yes 0 No

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / vivekk

Src-->SQ-->AGG-->RTR--->TG1 & TG2

In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.

Is This Answer Correct ?    1 Yes 0 No

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / laksh

You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.

Is This Answer Correct ?    2 Yes 2 No

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / balaramesh

using constraint based transformation

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Informatica Interview Questions

what is a time dimension? give an example?

2 Answers   IBM,

What is meant by a domain?

0 Answers  

How does a sorter cache works?

0 Answers  

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

What is meant by query override?

0 Answers  

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories