Enlist the advantages of informatica.
No Answer is Posted For this Question
Be the First to Post Answer
how can we calculate fact table size?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Sequence generator, when you move from develoment to production how will you reset
Explain the etl program with few examples.
what is the size of your data warehousing?
What is depict expression change?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
what is the size of u r source(like file or table)?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
what is Partitioning ? where we can use Partition?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
Briefly explain the aggregator transformation?