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
- 5867 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 |
Mention few test cases and explain them?
what are variable ports and list two situations when they can be used?
what are the concerns of OLTP and DSS systems?
Two default user groups created in the repository are____and_____.
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What is Data Vault???
how do u set partition points in the mapping?
what is the use of structures?how many nodes can u create in a structure?
What are the differences between sql override and update override?
what are the data modeling tools you have used?(polaris)
Explain the difference between etl tool and olap tools?
Teradata 
