Can there be sub steps of etl steps?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the key challenges that you face while performing etl testing.
Give 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?
what is a test load?
what is Forward,Reverse and Re_engineering?
what is pmrep command?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
In Which Transformation We Can Use Having Clause In Informatica?
Do we need an etl tool?
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?
what is session partitioning?
how do u decide whether u need to do aggregations at database level or at Informatica level?