how lookup transformation is made active in new versions...
When to use connected and when to use unconnected lookup and why? which is good for session performance.
How to make lookup persistent and how to remove stale data from that lookup.
how commit works - when we stop or abort data. Explain in both cases.
What is factless fact table and have you ever used it in real time scenarios.
No Answer is Posted For this Question
Be the First to Post Answer
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What are the measure objects?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
explain about unit testing? in real time?
what is fact table?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
star and snowflake schema?
Enlist some properties of sessions.
1 lac of flat fles in source how to load target at a time?
what is row level and column level indicator?
What are multi-group transformations?