Interested to Buy Any Domain ? << Click Here >> for more details...
I have a Flat file with more no. of Records also including
duplicate values. But i need distinct values to one target and
remaining records to another target in Informatica way
- 2 Answers
- 5929 Views
- I also Faced
- E-Mail Answers
Answer Posted / naveen
1)Use a router , create 2 different groups
2) let both the groups have the same condition in it . eg:
if ur source have got emp _id column and the max value in
it is 1000. Let ur condition in the router be emp_id <= 1000
3) remember , u put both the conditions in the router are
same . Because only then both the groups will fetch full
set of records , eg , if 100 records are ther in the
source , u can get 200 records from these 2 groups totally
4) from the first group, link a sorter or rank
transformation , enable select distinct in that and pass it
to the target
5) connect the other group from the router directly to
another target.
6) enjoy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain different types of partitioning?
what make u disappointmnets in u r career
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
how to load the data to fact table?
What is etl process?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what are the reporting tools and difference between them?
How many steps etl contains explain with example?
Explain about the data integration suite features?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the data modeling tools you have used?(polaris)
what is an ETL or ETT? And what are the different types?
what are the concerns of OLTP and DSS systems?
how does the server recongnise the source and target databases.Elaborate on this
