Explain pushdown optimization and types in informatica


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What are multi-group transformations?

0 Answers   Informatica,


What is Data Caches size?

0 Answers   Informatica,


Explain lookup transformation source types in informatica

0 Answers   Informatica,


What is log file,and where is it located,why u r using the log file

1 Answers   TCS,


where to store informatica rejected data?

0 Answers  


What is the difference between Power Centre and Power Mart?

5 Answers   TCS,


what are the output files that the informatica server creats during running a session?

2 Answers   CTS,


If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,


What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,


Categories