To achieve the session partition what r the necessary tasks
u have to do?
Answer Posted / swetha
Configure the session to partition source data.
Install the informatica server on a machine with multiple CPU's.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the sequence generator transformation in informatica?
What the difference is between a database, a data warehouse and a data mart?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Could you explain what is enterprise data warehouse?
How to use pmcmd utility command?
How to update or delete the rows in a target, which do not have key fields?
What is the need for an etl tool?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are junk dimensions?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is olap (on-line analytical processing?
What is an Integration service in Informatica?
How many ways are there to create ports?
How to create a non-reusable instance of reusable transformations?
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.