What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?10 24226
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need7 16824
What is checksum termnology in informatica? Where do you use it ?3 21023
What is the term PIPELINE in informatica ?7 26637
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance14 21782
How to handle changing source file counts in a mapping?3 12745
What are set operators in Oracle3 12829
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this9 11826
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic21 22994
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?2 10761
can u apply SCD2 on flat file tgt? if yes wat is the procedure?3 16021
What is the difference between IN and Exists in Oracle?3 11376
Can we have a Mapping without a Source Qualifier?14 31843
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?2 9247
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 400007 20158
What are distributed partitioned views?
What is spawn in node js?
Explain the truncate command?
Gave a cantilever beam with 3 legs.Told to draw the bending moment diagrams, axial force diagrams and shear force diagrams.From BMD he asked to show how the reinforcement will be provided on the tension side.
What are the different types of extension interface that is present in hibernate?
How can we set class to be inherited, but prevent the method from being over-ridden?
Explain the properties of union.
What is $_ request?
Connection diagram for KW meter and Kva meter
What is maintaining database?
Can intelligence server integrate with my existing data structure?
What is the necessity of heat sink?
What is database server?
is it possible to print selections of text rather than entire messages?
what is session partitioning?