In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What is tracing level? How many types of transformations supported by sorted input?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
what are the reporting tools and difference between them?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Identifying the bottlenecks in various components of Informatica and resolving them.
where is the cache (lookup, index) created and how can you see it.
what is data modeling?
how would u estimate the size of Aggregator transform data and index cache?
Explain etl mapping sheets?
What are various etl tools in the market?
what is a worklet?
Is apache nifi an etl tool?
where are the log files generally stored.Can you change the path of the file.what can the path be?
what are the concerns of OLTP and DSS systems?