when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?1614
what is the difference between normal & bulk loading? and which one is recommended ? why?2 5274
what is a test load?3 14945
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?1697
what is the difference between shortcut of an object and copy of an object? compare them?1 5205
what are business components in Informatica?2 9832
what is the advantage of persistent cache? when it should be used?2 3352
Two different admin users created for repository are________and_________.1 3017
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?1297
Compare etl & elt?
what is the difference between cubes and package in cognos
What do you understand by active and passive transformations?
how would u estimate the size of Aggregator transform data and index cache?
how many maximum session supports to multiload in teradata ??
what is pmrep command?
how do u set partition points in the mapping?
How many steps etl contains?
list and discuss two approaches for updation of target table in Informatica and how they are different.
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What are three tier systems in etl?
what are the data modeling tools you have used?(polaris)
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
In Which Transformation We Can Use Having Clause In Informatica?
Explain the use lookup tables and Aggregate tables?