When do you use a unconnected lookup and connected lookup.
Which is better among connected lookup and unconnected lookup transformations in Informatica or any other ETL tool?
At what levels can you define parameter files and what is the order?
Define Informatica repository?
How can we store previous session logs
How do you define fact less Fact Table in Informatica
How many types of TASKS we have in Workflow Manager? What are they?
How to read rejected data or bad data from bad file and reload it to target?
In my source table 1000 rec's are there.I want to load 501 rec to 1000 rec into my Target table
?How can you do this ?
What are different kinds of repository objects? And what it will contain?
What are the differences between informatica6.1 and informatica7.1
What are the session parameters?
What can we do in mapplets,that we cannot do in mappings
What is bottleneck in Informatica?
What is inline view?
What is source qualifier transformation?
What is the difference between power connect and power centre? What is the use of power
What is the procedure to load the fact table.Give in detail?
When do you use Normal Loading and the Bulk Loading, Tell the difference?
Which objects are required by the debugger to create a valid debug session?
Briefly explian the Versioning Concept in Power Center 7.1.
Define mapping and sessions?
How can we use pmcmd command in a workflow or to run a session
How do you define partitions in Informatica?
How many ways you can update a relational source defintion and what are they?
How to recover sessions in concurrent batches?
In realtime which one is better star schema or snowflake star schemathe surrogate will be linked
to which columns in the dimension table.
What are Dimensions and various types of Dimensions?
What are the different options used to configure the sequential batches?
What are the settings that you use to configure the joiner transformation?
What does Check-In and Check-Out option refer to in the mapping designer?
What is bulk bind? How does it improve performance?
What is intermediate task in Informatica? In what situation this task will be executed?
What is SQL mass updating?
What is the difference between PowerCenter 6 and powercenter 7?