1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

can we load the data with out a primary key of a table?
what is target plan?

Question Posted / manjunath

Answer Posted / manjunath

Yes, we can load the data without the primary key, but if you want to use furhtet i.e to update we cant do it, for that we need primary key.

Target Load Plan : It is used if we have multiple sources and targets we go for this option (We can have this option in Mapping Tab)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

wf dont have integration severances how you can run?

1541

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6757

How to join three sources using joiner? Explain though mapping flow.

704

What is the sequence generator transformation in informatica?

615

How we can create indexes after completing the load process?

616




What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1189

Explain how to import oracle sequence into informatica?

594

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

643

What is a sequence generator transformation?

579

What is decode in informatica?

661

How we can use union transformation?

612

what is song in infrmatica...?

1681

What are the modules in Power Center

1240

What are the designer tools for creating transformations?

687