What are the steps involved in the migration from older version to newer version of Informatica Server?
No Answer is Posted For this Question
Be the First to Post Answer
without dynamic lookup transformation how to insert new rows and update existing rows?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Which transformation is needed while using the Cobol sources as source definitions?
What is the filename which you need to configure in UNIX while installing infromatica?
why we are using level option in normalizer transformation
What is decode in informatica?
Why use the lookup transformation ?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
disable caching in a lookup transformation?