what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
Post New Answer View All Answers
Define the various join types of joiner transformation?
How to join three sources using joiner? Explain though mapping flow.
What is informatica powercenter repository?
What is lookup change?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
explain one complex mapping with logic? sales project?
Is there any way to read the ms excel datas directly into informatica?
How to do unit testing in informatica? How to load data in informatica ?
permutations of mapplet
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the settings that you use to configure the joiner transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What happens when a session fails and you click on recover?