how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answer Posted / sivananda reddy
In informatica use this mapping
source->sqr->aggr->router->exp->target1
|
|->exp->target2
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you load first and last records into target table?
What do you mean by worklet?
What is Cognos script editor?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is a router transformation?
How are indexes created after completing the load process?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Define mapplet?
What are data-driven sessions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the advantages of using informatica as an etl tool over teradata?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Implementation methodology
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.