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

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

What is diff joiner and lookup

4 Answers   BirlaSoft,

What is informatica etl tool?

0 Answers  

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

What is blocking transformation?

0 Answers   Informatica,

What is target update override

2 Answers   CTS,

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

expain about the tune parameters?

0 Answers   TCS,

what is a transforamation?

5 Answers  

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

For more Informatica Interview Questions Click Here
Categories