can we load the data with out a primary key of a table?
what is target plan?
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
What are data-driven sessions?
What is dimensional table? Explain the different dimensions.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Reusable transformation and shortcut differences
Implementation methodology
What are the different options available for update strategy?
Target increases every day even though no new record was inserted
How do you promote a non-reusable transformation to reusable transformation?
Where do we use mapping variables in informatica?
According to his methodology what all you need before you build a datawarehouse
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to load a Dimension ? and how to load a fact table?
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.
can any one give some examples for pre sql and post sql(Except dropping and creating index).