What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?10 24465
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need7 16927
What is checksum termnology in informatica? Where do you use it ?3 21185
What is the term PIPELINE in informatica ?7 26806
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 21988
How to handle changing source file counts in a mapping?3 12965
What are set operators in Oracle3 12897
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 12001
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 23397
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 10859
can u apply SCD2 on flat file tgt? if yes wat is the procedure?3 16250
What is the difference between IN and Exists in Oracle?3 11448
Can we have a Mapping without a Source Qualifier?14 32175
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?2 9318
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 20435
What are the components of qlikview’s architecture?
what are the different application servers and web servers supporting j2ee technologys?
How do I setup mysql?
What is the maximum rows in csv?
What is cdata in xml?
Is java required for spark?
Which program is useful for testing jQuery?
How do I create a different sized table in word?
What are the steps to send and receive JMS message ?
What is meant by latch?
What is bootup process?
What is the one thing that you regret?
What are default parameters? How are they evaluated in c++ function?
Differentiate between Balance of Trade and Balance of Payment?
what is the difference between a primary key and a unique key? : Sql server database administration