In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / naga
Flat file is better only for Insert,but if you are using
Update strategy for updating a table then table gives
better performance and FYI a Flatfile cannot be updated
Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
How many ways a relational source definition can be updated and what are they?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are connected or unconnected transformations?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What all are steps in up gradation of Informatica server?
Explain lookup transformation is active in informatica
what are the deliverables?in your project?
what is Active lock explain
wat are deployement groups in informatica, how it will be used for developers
How do you change a non-reusable transformation to reusable transformation?
What are the modules in Power Center
Enlist the various types of transformations.