How to enter same record twice in the target table,explain?
- 7 Answers
- 11665 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 to configure mapping in informatica?
Useful UNIX commands regular/frequently used
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
What are the tasks that can be performed using sq?
how to convert the .doc docs into .txt format using informatica
sample mappings for scd1,scd2 and scd3
How to prepared lld.can any one tell me detailed explanetion.
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
what is filelist concept in informatica
i have source in oracle 10g,oracle 8i how will u take the data from two sources
What is A cache?
Teradata 
