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?
1746How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
1825A 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?
1445
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Compare ETL & Manual development?
What is data modeling and data mining?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the use of server manager?
What is etl process. How many steps etl contains explain with example?
Explain the difference between etl tool and olap tools?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how do u identify the changed records in operational data?
What is a lookup table in etl?
Is hadoop a etl tool?
what is a worklet?
When do we analyze the tables? How do we do it?
What is etl process?