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
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 |
what are the reporting tools and difference between them?
what is the meant by Normalization and de-normalization?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
what is the difference between OLTP database and data warehousing database?
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?
how do u handle performance issues in Informatica . where can u monitor the performance ?
how do u implement scheduling in Informatica?
What is partitioning? Explain about round-robin, hash partitioning.
without using ETL tool can u prepare a Data warehousing and maintaining?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?