|
Related Questions |
View Answer |
|
Whats the diff between Informatica powercenter server, repositoryserver and repository?
|
View Answer
|
|
How to create the staging area in your database
|
View Answer
|
|
What does the expression n filter transformations do in Informatica Slowly growing target wizard?
|
View Answer
|
|
In a filter expression we want to compare one date field with a db2 system field CURRENT DATE. Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator).. Can someone help us. Thanks
|
View Answer
|
|
Briefly explian the Versioning Concept in Power Center 7.1.
|
View Answer
|
|
How to join two tables without using the Joiner Transformation.
|
View Answer
|
|
Identifying bottlenecks in various components of Informatica and resolving them.
|
View Answer
|
|
Identifying bottlenecks in various components of Informatica and resolving them.
|
View Answer
|
|
Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.
|
View Answer
|
|
How do you decide whether you need ti do aggregations at database level or at Informatica level?
|
View Answer
|
|
How do we estimate the depth of the session scheduling queue? Where do we set the number of maximum concurrent sessions that Informatica can run at a given time?
|
View Answer
|
|
How do we estimate the number of partitons that a mapping really requires? Is it dependent on the machine configuration?
|
View Answer
|
|
Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
|
View Answer
|
|
We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.
|
View Answer
|
|
What is the procedure to write the query to list the highest salary of three employees?
|
View Answer
|
|
Which objects are required by the debugger to create a valid debug session?
|
View Answer
|
|
What is the limit to the number of sources and targets you can have in a mapping
|
View Answer
|
|
Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?
|
View Answer
|
|
In Dimensional modeling fact table is normalized or denormalized?in case of star schema and incase of snow flake schema?
|
View Answer
|
|
What is difference between IIF and DECODE function
|
View Answer
|