After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?
Answer Posted / kanth
Here they are having Heterogeneous sources how can those
can be joined at source quaifier.i think the question is
not clear u cannot darg the three heterogeneous siurces to
sinle source qualifier
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
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?
Explain sessions. Explain how batches are used to combine executions?
Explian the Process of deployment groups in informatica
How can we remove the duplicates from flat file source?
What is the meaning of decode in informatica?
What are the types of lookup transformation?
What is powercenter on grid?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a router transformation?
What is joiner transformation in informatica?
What are roles and groups and benefits of using them?
What is target designer and target load order?
Explain Dataware house architecture .how data flow from intial to end?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is Session and Batches?