-
Index and Data Cache
what is the difference between index cache and data cache
-
-
Update Strategy
In which situation do we use update strategy?
-
Dimension Table Vs Fact Table
What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.
-
Target Details Verification
If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.
-
Joiner Transformation Master Detail
Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?
-
-
-
-
-
-
-
-
-
-
-
-
-
How many number of sessions that u can create in a batch?
Any number of sessions.
-
Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server?
Informatica server manager.
-
What is Session and Batches?
Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the session.Batches - It Provides A Way to Group Sessions For Either Serial Or Parallel Execution By The Informatica Server. There Are Two Types Of Batches...