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
- 19370 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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Enterprise data warehouse your projects phase by phase explain?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
difference between repository database and repository service?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What do you mean by blocking transformation?
What is data transformation manager process?
Can you generate sequence numbers without using the sequence generator transformation?
generate date / time dimension in informatica
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is joiner transformation?
can we override a native sql query within informatica? How do we do it?
difference between informatica 8.1.1 and 8.6
