Can we use different lookup tranformations for a same
lookup table (lookup condition may or may not be same)with
different output ports? How the cache files will be
affected? Please clarify..
what is scd?
Can we have a Mapping without a Source Qualifier?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
when we go for unconnected lookup transformation? and why?
what are the limitations of pushdown optimization technique ? Advance thanks
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Enlist few areas or real-time situations where informatica is required.
how to we create datamart?
What are batches?
Write the program through which the records can be updated?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
what are the challenge face in u r project?explain me