How do you implement configuration management in Informatica?
We can do the necessary configuration settings by logging into the domain from browser with admin access. Sometimes, we need to restart the Integration Service after change which can be done from here with admin access.
Is This Answer Correct ? | 1 Yes | 0 No |
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What are the new features of the server manager in the informatica 5.0?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How to delete duplicate record in Informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
Why we require dwh in particular projects?
What are the different tools in workflow manager?
Define sessions in informatica etl?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?