|
Question |
Rating |
View Answer |
|
If the workflow has 5 session and running sequentially and 3rd session hasbeen failed how can we run again from only 3rd to 5th session?
|
|
View Answer |
|
How many types of dimensions are available in Informatica?
|
|
View Answer |
|
Can batches be copied/stopped from server manager?
|
|
View Answer |
|
How can I get distinct values while mapping in Informatica in insertion?
|
|
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 |
|
What is the difference between constraind base load ordering and target load plan
|
|
View Answer |
|
What is the Rankindex in Ranktransformation? |
|
View Answer |
|
What are the rank caches? |
|
View Answer |
|
What is difference between maplet and reusable transformation? |
|
View Answer |
|
Where to store informatica rejected data? How to extract the informatica rejected data ? |
|
View Answer |
|
What will happen if you are using Update Strategy Transformation and your session is configured for "insert"?
What are the types of External Loader available with Informatica?
If you have rank index for top 10. However if you pass only 5 records, what will be the output of such a Rank Transformation?
|
|
View Answer |
|
Can we use aggregator/active transformation after update strategy transformation
|
|
View Answer |
|
While running multiple session in parallel which loads data in the same table, throughput of each session becomes very less and almost same for each session. How can we improve the performance (throughput) in such cases?
|
|
View Answer |
|
Which tool you use to create and manage sessions and batches and to monitor and stop the informatica server? |
|
View Answer |
|
To achieve the session partition what are the necessary tasks you have to do? |
|
View Answer |
|
How do you handle decimal places while importing a flatfile into informatica?
|
|
View Answer |
|
What is the difference between stop and abort
|
|
View Answer |
|
In certain mapping there are four targets tg1,tg2,tg3 and tg4. tg1 has a primary key,tg2 foreign key referencing the tg1's primary key,tg3 has primary key that tg2 and tg4 refers as foreign key,tg2 has foreign key referencing primary key of tg4 ,the order in which the informatica will load the target? 2]How can I detect aggregate tranformation causing low performance?
|
|
View Answer |
|
Can u copy the session to a different folder or repository?
|
|
View Answer |
|
What are two types of processes that informatica runs the session? |
|
View Answer |