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
- 5937 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 the methodology of Data Warehousing?(Polaries)
what are Lookup caches options? Including persistent caches.
flat filevalidation in informatica
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.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?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
What is tracing level?
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?
what are variable ports and list two situations when they can be used?
Which transformation we use to convert 'NA' to 'Not Available'
what is the meaning of upgradation of Repository?
Teradata 
