Interested to Buy Any Domain ? << Click Here >> for more details...
How to enter same record twice in the target table,explain?
- 7 Answers
- 14039 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 |
Could any one to tell Fact table Partitioning?
What is domain and gateway node?
what is a transforamation?
How will you display "Mr" for male & "Mrs" for female in target table?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
Why we use partitioning the session in informatica?
what is the dashbords?
Insert else update option in which situation we will use
What are the different tools in workflow manager?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
Teradata 
