How to enter same record twice in the target table,explain?
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 |
What is lookup transformation?
Explain the aggregator transformation?
What are the restrictions of union transformation?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
How might one distinguish in the case of mapping is right or not without associating session?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
why we need informatica
what is the process of target load planing?
Name 4 output files that informatica server creates during session running?
Why should we use star schema in datawarehouse design?
What is the difference between router and filter?