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?
When we are logging into Informatica repository for the First Time, the Metadata is getting imported into the Repository. This is why from the second time, we don't need to provide username & database or domain name. Only for authentication purpose, we have to provide the password.
| Is This Answer Correct ? | 5 Yes | 0 No |
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
why do we go for update strategy tr in SCD rather using the session properties?
How can we use mapping variables in informatica?
scenario where i can use only concurrent execution of workflow.
How can we improve session performance in aggregator transformation?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What are the components of Informatica? And what is the purpose of each?
What is the Router transformation?