What is difference between partioning of relatonal target
and partitioning of file targets?
Answer Posted / swetha
If you parttion a session with a relational target
informatica server creates multiple connections o the
target database to write target data concurently.If you
partition a session with a file target the informatica
server creates one target file for each partition. yoU can
configure session properties to merge these target files.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the function of look up transformation?
What is meant by lookup transformation?
What do you mean by enterprise data warehousing?
what is informatica metadata?
Briefly define a session task?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is a standalone command task?
How can you generate reports in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
Where is metadata stored?
How big was your fact table
According to his methodology what all you need before you build a datawarehouse
Explain Dataware house architecture .how data flow from intial to end?
What are the components of the workflow manager?
What is an expression transformation in informatica?