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
- 19344 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer Posted / sanju_yu
source> dynamic lookup>router,2 conditions in router
1. condition if column_lkp port is null then insert into
target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates
Plz let me know if am wrong
Sanjay
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is an expression transformation in informatica?
How can one identify whether mapping is correct or not without connecting session?
What is sorter transformation?
How do you load first and last records into target table?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the code page compatibility?
What are the types of presistent cache in look up tr.
Briefly explain the aggregator transformation?
Did u used latest transformations of 8.6.0? for what?
How can we remove the duplicates from flat file source?
How are the sources and targets definitions imported in informatica designer?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
