Informatica Interview Questions - 6

26. Explain Lookup transformation ?
Lookup transformation is a passive transformation used to look up a source, source qualifier, or target to get the relevant data. Basically, it's a kind of join operation in which one of the joining tables is the source data, and the other joining table is the lookup table.
Types of Lookup are
Relational or flat file lookup.
Pipeline lookup.
Connected or unconnected lookup.
Cached or un-cached lookup.

27. What is the use of Repository Manager ?
Repository Manager is used to perform admin roles like creating folders in the repository, deleting the folders, editing the folders, exporting the objects, importing the objects etc. Folders provide a way to organize and store metadata in the repository, including mappings, schema’s, and sessions. Folders help you logically organize the repository.

28. Explain joiner transformation ?
The joiner transformation is an active and connected transformation used to join two heterogeneous sources. The joiner transformation joins sources based on a condition that matches one or more pairs of columns between the two sources. The two input pipelines include a master and a detail pipeline or branch.

29. Lists different types of Workflow tasks ?
Session task – it needed to run a mapping.
Assignment task – can establish the value of a Workflow Variable whose value can be used at a later point in the workflow
Decision task – enables the workflow designer to set criteria by which the workflow will or will not proceed to the next set of tasks.
Email task – sends an email from within a workflow.
Event wait task – pauses processing of the pipeline until a specified event occurs.
Command task – specifies one or more UNIX command or shell script.

30. Explain code page compatibility ?
When data moves from one code page to another provided that both code pages have the same character sets then data loss cannot occur. All the characteristics of source page must be available in the target page. Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data loss. One code page can be a subset or superset of another.