how do u use sequence created in oracle in informatica?
Explain with an simple example
Answer Posted / sujay
by writing sql override in the source qualifier by calling
sequence which you have created in oracle
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the features of complex mapping?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a standalone command task?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain the tuning lookup transformation - informatica
How do you set a varible in incremental aggregation
Differences between version 7.x and 8.x.
What all join we can perform in LOOKUP transformation?
How would you join a node to the already existing domain?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain the aggregator transformation?
How can we use batches?
What is meant by incremental aggregation?
Which development components of informatica have the highest usage?
What is dimensional table?