How to enter same record twice in the target table,explain?
Answers were Sorted based on User's Feedback
Answer / guest
Guess,Connect the output to two instances of same target
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / saradhi
i think its happen only if the target table does not have
any primary key.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / guest
Guess this can be done only by if the target table has a an
id which is of serial number or the table does not have
promary keys
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / informatica_learner
use the transformation of nomalizer transformation
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ramesh
use nomalizer transformation and you can set occurancy
level
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shankar
if there is primary key there then this cant be done. we get an error 'unique constraint violated'error. hence very less scope here. if we can assign any i.d then there might be some scenarios where we can do this.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between a table and the materialized view?
Mapplets can you use an active transformation in a mapplet,
What is the use of target designer?
How union transformation is active ?
where is the reject loader .
Name 4 output files that informatica server creates during session running?
How to delete duplicate record in Informatica?
What are the different tools in workflow manager?
performance wise which one is better in joiner and lookup transformation
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
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.