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
- 19217 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 Session and Batches?
What are the tasks that can be performed using sq?
Name the different lookup cache(s)?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Enlist few areas or real-time situations where informatica is required.
What are the differences between joiner transformation and source qualifier transformation?
What is the surrogate key?
Differentiate between router and filter transformation?
How big was your fact table
What does role playing dimension mean?
Write the prerequisite tasks to achieve the session partition?
What is the sequence generator transformation in informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Difference between Target-based loading and constraint-based loading?
