Interested to Buy Any Domain ? << Click Here >> for more details...
How to enter same record twice in the target table,explain?
- 7 Answers
- 13716 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 |
can we load the data with out a primary key of a table? what is target plan?
Do you find any difficulty while working with flat files as source and target?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
Where can we find the throughput option in informatica?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What is the difference between stop and abort in informatica
Why do you use Mapping Parameter and mapping variable?
Can anyone please distinguish what is Inner join and Outer join
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
Design a mapping to get year of join for each employee.
Teradata 
