Interested to Buy Any Domain ? << Click Here >> for more details...
How to enter same record twice in the target table,explain?
- 7 Answers
- 14213 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 |
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what is the difference between repository & Intergration service
Is snow flake or star schema used? If star schema means why?
 Code page compatibly –Where all changes are made to handle the scenario.
How can u work with remote database in informatica?did you work directly by using remote connections?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
What is a shortcut and copy in Informatica and how two are different with each other?
sample mappings for scd1,scd2 and scd3
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Teradata 
