What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?10 25646
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need7 17677
What is checksum termnology in informatica? Where do you use it ?3 21844
What is the term PIPELINE in informatica ?7 27513
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 23170
How to handle changing source file counts in a mapping?3 13510
What are set operators in Oracle3 13243
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 12617
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 24963
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 11310
can u apply SCD2 on flat file tgt? if yes wat is the procedure?3 17470
What is the difference between IN and Exists in Oracle?3 11881
Can we have a Mapping without a Source Qualifier?14 33604
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?2 9672
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 21290
List some aggregates methods provided by query builder in laravel?
What is windows phone?
How do I use sparklines in excel 2016?
What are the PeopleSoft reports that need to be executed before and after a patch is applied? Why? What do they do? How do you resolve issues that appear on these reports?
Tell us what is ics?
Name kinds of Cluster Managers in Spark?
If you were to drill a circular hole in a sheet of metal and then heat the sheet, what would happen to the size of the hole?
Where can I find chkdsk results in windows 7?
Explain the process of including heat exchangers in ammonia refrigeration system?
At the point, you should go for struts framework?
Do hard drives go bad if not used?
What are the Configuration files in .net?
How to update info already in a table and delete a row(s) from a table.
What are constants used for?
Why we use mho Relay in long transmission line?