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

Can we get 1st record through Informatica(without sequence number).

0 Answers  


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


Define pmcmd command?

0 Answers  


What is IQD file?

1 Answers  


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


How to recover the standalone session?

2 Answers  


suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,


What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  


Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,


Which is better performance wise database or file?How?

2 Answers   TCS,


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,


Explain what transformation and how many are there in informatica?

0 Answers  


Categories