What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?10 23717
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need7 16505
What is checksum termnology in informatica? Where do you use it ?3 20774
What is the term PIPELINE in informatica ?7 26286
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 21471
How to handle changing source file counts in a mapping?3 12490
What are set operators in Oracle3 12628
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 11522
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 22349
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 10549
can u apply SCD2 on flat file tgt? if yes wat is the procedure?3 15594
What is the difference between IN and Exists in Oracle?3 11211
Can we have a Mapping without a Source Qualifier?14 31244
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?2 9102
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 19593
When connection to database is failed, Which exception will be thrown?
What is placement new?
What is an index? How can an index be declared in mysql?
Hi SD Gurus, Have you generated any customized Pricing Reports for your client? If you have done then list out all the customized Pricing Reports for your client? Please do not attach much importance to theory and do concentrate more on Business Scenario where in the client was insisting on customized reports rather than Standard Pricing reports? Give detailed Configuration& Customization Procedure, steps, Path, T-codes (if any), Analysis, logic & finally solution to your Client’s requirement along with detailed explanation? Please give solutions with reference to your real time data examples from your client/ Project? This question related to Pricing is most important as it is being asked more frequently in many Interviews? I have interview within 1-2 days? So, I request you to provide solutions to above question as early as possible? Your timely help would be greatly appreciated? Thanks in advance Regards
Will the table size in SAP HANA database and in the source system the same?
What is ajax in laravel?
How does client object model works?
What is local storage concept in HTML 5?
How can Visual Basic be used for server-side scripting?
what is flash tweening? : Adobe flash
Explain what is the limit of data.com records that can be added to Salesforce?
Give an acccount of aeromonas ?
What is the difference between aggregate table and materialized view?
Explain difference between nfs soft and hard mouniting points?
If you have requirement from client for some scenario how will you choose the instance type?