Consider two cases:
(1) Power Center Server and Client on the same machine
(2) Power Center Sever and Client on the different machines
what is the basic difference in these two setups and which is recommended?
Answer Posted / subhrangshu
That's absolutely correct. Client and Server should be in different machines because of security purpose, safety issues & obviously for more access.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
which one is better performance wise joiner or look up
Explain target update override in informatica
Explain lookup transformation is active in informatica
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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are multi-group transformations?
How to go to the older version for a mapping?
What are the differences between oltp and olap?
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 ?
Explain sessions. Explain how batches are used to combine executions?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
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.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?