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

Post New Answer

More Informatica Interview Questions

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?

2 Answers   TCS,


what is surrogate id ?

3 Answers   IBM,


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?

2 Answers   CTS,


In a sequential batch can you run the session if previous session fails?

4 Answers  


Write the advantages of partitioning a session?

0 Answers  






What are the types of maping in Getting Started Wizard?

1 Answers  


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?

2 Answers   CTS,


What are different types of transformations available in informatica?

0 Answers  


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?

8 Answers   HeadStrong, TCS,


What is rank transform?

0 Answers  


Can we run session without using workflows?

5 Answers   TCS,


Mention few power centre client applications with their basic purpose?

0 Answers  


Categories