How to calculate the cache size if say we are doing a
performance check on a mapping and found that a particular
cache needs to be changed. Is there a formula to calculate
this! i know that informatica has a auto option available
but how to calculate manually?
How can we use mapping variables in informatica?
Explain sessions. Explain how batches are used to combine executions?
how to load rows into fact table in data warehouse
what is the diff b/w union and joiner and lookup?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
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 PARFORM INCREMENTAL LAOD ?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
Which are the different editions of informatica powercenter that are available?
Informatica and datawarehousing courses in Pune?
What is a standalone command task?