Monday 30 June 2014

HCL informatica Interview

What is session?
What is workflow?
What is worklet?
Which ETL tool is more preferable Informatica or Data Stage and why?
What is a mapplet?
What is the use of auxiliary mapping?
What is authenticator?
How do we create primary key only on odd numbers?
What is the difference between source qualifier transformation and application source qualifier transformation?
What are the types of loading in Informatica?
What is the use of control break statements?
What is the difference between active transformation and passive transformation?
What are the various types of transformation?
What is the use of tracing levels in transformation?
What is the difference between a Database and a Datawarehouse?
What are the different types of OLAP TECHNOLOGY?