how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
CTS,
2 7243can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
1965Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
1893how 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?
2035how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
2263
tell me few points when u become TL
Is apache nifi an etl tool?
SCD2 will work on only dimension tables as well as fact Table?
Identifying the bottlenecks in various components of Informatica and resolving them.
what are the reports developed in sap bw project and what is the requirement for developing it?
What is data modeling and data mining?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What are the three tiers in etl?
what are the session parameters? How do u set them?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Explain and compare etl & manual development?
what make u disappointmnets in u r career
Explain do we need an etl tool?
what are the production issues in datastage?
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?