Interested to Buy Any Domain ? << Click Here >> for more details...
Hi
If i had source like unique & duplicate records like 1,1,2,3,3,4
then i want load unique records in one target like 2,4 and i want
load duplicate records like 1,1,3,3 then can any body please send
me what is th scnario. my mail i
shek.inform@gmail.com
- 6 Answers
- 19315 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer Posted / shirish
1.For unique: Source-->SrcQualifier--> sorter (use distinct
option)--> Target
2. For duplicate : Source-->SrcQualifier-->Aggregator(group
by this column and find count also)-->filter(use count
greater than 1 )--> left outer join with source qualifier --
> target 2.
Hope i am clear.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How do you load only null records into target?
What are the main issues while working with flat files as source and as targets ?
Is it possible to create multiple domains on a single Informatica server?
Could you explain what is enterprise data warehouse?
What are the tasks that can be performed using sq?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain your project of banking domian.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a predefined event?
What is the meaning of decode in informatica?
Mention few advantages of router transformation over filter transformation.
What is the use of transformation?
What is domain and gateway node?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
