How to enter same record twice in the target table,explain?

Answers were Sorted based on User's Feedback



How to enter same record twice in the target table,explain?..

Answer / guest

Guess,Connect the output to two instances of same target

Is This Answer Correct ?    10 Yes 0 No

How to enter same record twice in the target table,explain?..

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

How to enter same record twice in the target table,explain?..

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

How to enter same record twice in the target table,explain?..

Answer / informatica_learner

use the transformation of nomalizer transformation

Is This Answer Correct ?    4 Yes 2 No

How to enter same record twice in the target table,explain?..

Answer / ramesh

use nomalizer transformation and you can set occurancy
level

Is This Answer Correct ?    2 Yes 0 No

How to enter same record twice in the target table,explain?..

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 enter same record twice in the target table,explain?..

Answer / peer

with the help of warehouse keys

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is lookup transformation?

0 Answers  


Explain the aggregator transformation?

0 Answers  


What are the restrictions of union transformation?

0 Answers  


Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  


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?

0 Answers  


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

0 Answers   Infotech,


why we need informatica

2 Answers   HCL,


what is the process of target load planing?

2 Answers   IBM,


Name 4 output files that informatica server creates during session running?

1 Answers  


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


What is the difference between router and filter?

0 Answers  


Categories