Lookup transformation, one condition is having SQL override
(Empno < 10) and the other condition is Lookup (Sal>1000),
which is dynamic. How will u resolve this situation?
No Answer is Posted For this Question
Be the First to Post Answer
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
what is surrogate id ?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
In a sequential batch can you run the session if previous session fails?
Write the advantages of partitioning a session?
What are the types of maping in Getting Started Wizard?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
What are different types of transformations available in informatica?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What is rank transform?
Can we run session without using workflows?
Mention few power centre client applications with their basic purpose?