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
- 5725 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 the different Lookup methods used in Informatica?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is data cleaning?
Is hadoop a etl tool?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Explain me ETL project architecture in Detail?
what is the main role of FI on business
What is Data Vault???
what do u do when DB time takes more?in sap bi
what is data modeling?
Explain about etl data integration software?
where is the cache (lookup, index) created and how can you see it.
What is partitioning? Explain about round-robin, hash partitioning.
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
