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
- 19318 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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is SDLC way of code development?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different versions of informatica?
What is fact table? Explain the different kinds of facts.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What do you mean by channel change?
What are pre and post-session shell commands?
Where is metadata stored?
How can we create index after completion of load process?
How to generate sequence numbers without using the sequence generator transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the reusable transformations?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Why sorter is an active transformation?
