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?
1614How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
1697A 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?
