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
- 19546 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
is it possible to index the data in cache of lkp transformation ?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Why sorter is an active transformation?
Explain sql transformation in script mode examples in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to load the data from people soft hrm to people soft erm using informatica?
What is the use of target designer?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What differs when we choose the sorted input for aggregator transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Write the unconnected lookup syntax?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
