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 |
Tell me about Propagate functions in informatica
What happens if we dont select data driven option?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Explain lookup transformation is active in informatica
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to configure mapping in informatica?
Limitation of REPLACESTR. Is there any character limitation to it.
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression