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
- 5853 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
What are three tier systems in etl?
what is pmrep command?
Explain the key challenges that you face while performing etl testing.
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how to connect to a flatfile through ftp in informatica
Identifying the bottlenecks in various components of Informatica and resolving them.
how do use session mapping parameters ?(in which transformation)
Explain me ETL project architecture in Detail?
What are the steps involved in etl process?
What is tracing level?
Explain etl mapping sheets?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
how do u really know that paging to disk is happening while u are using a lookup transform?
What is virtual Data Warehousing?
