When you connect to 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?
1 3278How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
1 4070A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
1 3936Post New Informatica Questions
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is source qualifier transformation in informatica?
How to delete duplicate row using informatica?
What is union transformation in informatica?
Explain lookup transformation in informatica
Explain the difference between mapping parameter and mapping variable?
How to update or delete the rows in a target, which do not have key fields?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Define sessions in informatica etl?
generate date / time dimension in informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the difference between informatica 7.0 and 8.0?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain the pipeline partition with real time example?
What is expression transformation?