What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?10 25160
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need7 17371
What is checksum termnology in informatica? Where do you use it ?3 21594
What is the term PIPELINE in informatica ?7 27271
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 22719
How to handle changing source file counts in a mapping?3 13305
What are set operators in Oracle3 13115
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 12397
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 24388
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 11146
can u apply SCD2 on flat file tgt? if yes wat is the procedure?3 17022
What is the difference between IN and Exists in Oracle?3 11726
Can we have a Mapping without a Source Qualifier?14 33096
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?2 9552
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 21010
What is the significance of geo fields on an object?
How do you automatically update fields in word?
To identify IDL language what mapping mechanism is used?
What are the maintenances of SCADA ?
The two types of services that are used to deal with communication?
How can we group heading elements in html?
What do you mean by platform independence of Java?
How can you retrieve data from the mysql database using php?
What is css and its features?
What is oracle rownum?
What is use of derived roles?
Explain the different ways of initiating transaction in cics?
How you’d control permissions through Profile?
How do I know I am reaching my target audience?
why did the ground terminal place in 3ble plug?