Which transformation can perform the non equi join?
How many star schemas can you use in a project? Is it possible to use more one star schemas?
If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?
Latest Answer: Follow the below steps-1. Create the mapping as if there is only single source and target.2. Now create an additional file on the server which will list the multiple source file names along with their paths.3. Specify the path and name ...
What is Power Exchange?
What are the Connectivity Issues that comes when we connect informatica to Oracle?
Latest Answer: There can be different reason for the connectivity to fail. It can be either or combination of below:1) Server is down.2) Wait time for the IS of Informatica is too low.3) Network is slow.4) The OS on the server (usually unix) might have not functioned ...
How does Informatica PowerCentre process records?
What are the newly added transformations in informatica powercenter 8.1.1?
Latest Answer: 1. Java Transformation
2. HTTP Transformation
3. SQL Transformation
4. Unstructured Data Transformation
...
Why Union Transformation is active while it passes all the rows through it.
Latest Answer: By definition, a transformation is treated as active if the number of input rows do not match the number of output rows. Since Union transoformation accepts input rows from multiple pieplines, and combines the rows, input rows are always greater than ...
How to create individual sequence numbers for each department wise?
Latest Answer: Here are the steps1. Assume that there are four departments and that the source is a source file that contains dept id.2. Create four Sequence Generator transformations.3. Create an expression transformation, configuration is as below- a. ...
How to use Lookup as Sequence?
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
