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
- 5858 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / naveen
1) use the router , create 2 diff groups
2) let both the groups have the same condition , eg: emp_id
> 1000 in both the groups. only then u will all the records
in both the groups
3) use a sorter or rank transformation to enable select
distinct option for the first group and send it to the
target
4) connect the second router group directly to the another
target
5) enjoy
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain etl mapping sheets?
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
What are your responsibilities as an etl tester?
What is etl tool in hadoop?
when should one create lookup transformation ?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
List few etl bugs?
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
what is the use of server?
Teradata 
