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 all, i am new to this site and new to Informatica too. I
have few questions regarding that.
1) When we load flat files into target tables how do we
identify duplicates? and where do load the duplicate
records for further reference?
2) How do we do chage data capture? Is this Slowly changing
Dimension technique?


Thanks in Advance

Question Posted / ram

Answer Posted / ram

take a router transformation and pass the records through the router transformation and write the logic as if setvarcount()<=1 then send to one target and if setvarcount()>1 then rout them to second target then u can easily avoid duplicates and also u can verify them for future use. try this else correct me

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you copy the content of one repository to another repository?

1058

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2780

What is meant by lookup transformation?

1181

Why update strategy and union transformations are active?

1093

What is a joiner transformation and why it is an active one?

1164

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1724

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2198

what is index?how it can work in informatica

2083

Explain constraint based loading in informatica

1155

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

How to do unit testing in informatica?

1229

have u done any performance tuning? how u ll do?

2364

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1962

What is the sql query overwrite in source qualifier in informatica

1142