without dynamic lookup how to insert new rows and update
existing rows?
In warehouses how many schemas are there?
Explain the different dimensions.
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
How will you display "Mr" for male & "Mrs" for female in target table?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
which one is better either active or passive transformation in informatica
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is batch and describe about types of batches?
why we r using presql&postsql in source qualifier?
what is system requirement(SR) & business requirement(BR)?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
what is the necessity to use update strategy?(except for updates)