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

Differnce between filter and router?

14 Answers   IBM,

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

explain about unit testing? in real time?

0 Answers   L&T,

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

update strategy transformation in informatica

0 Answers   Informatica,

what are objects in data warehouse?

2 Answers   Mind Tree,

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

Difference Between ETL & ELT?

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories