Explain the use lookup tables and Aggregate tables?
No Answer is Posted For this Question
Be the First to Post Answer
where we cannot use sorter Transformation. if we use then we will not get correct data?
How we can see table structure?
what is Forward,Reverse and Re_engineering?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
SCD2 will work on only dimension tables as well as fact Table?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is a lookup table in etl?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
what is the difference between normal & bulk loading? and which one is recommended ? why?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what are Lookup caches options? Including persistent caches.