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 |
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
What will be the approach?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
What is the format of informatica objects in a repository?
What is substr in informatica?
What is confirmed dimension and fact?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
How to delete duplicate record in Informatica?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
differences between service based and product based?
In which scenario did u used Mapping variable?