Interested to Buy Any Domain ? << Click Here >> for more details...
How to enter same record twice in the target table,explain?
- 7 Answers
- 14006 Views
- I also Faced
- E-Mail Answers
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 |
how may sources can be used in a mapping at a time?(limit)
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
how to create user defined function (udf) in informatica
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
how to run the batch using pmcmd command
How to differentiate between the active and passive transformations?
Can you copy the batches?
i have two source data there is no pk,fk how to join the two sources
Why do we need informatica?
what are the output files that the informatica server creats during running a session?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Teradata 
