Answer Posted / swetha
Join data originating from same source data base.
Filter records when the informatica server reads source data.
Specify an outer join rather than the default inner join
specify sorted records.
Select only distinct values from the source.
Creating custom query to issue a special SELECT statement
for the informatica server to read source data.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the designer tools for creating transformations?
How to join three sources using joiner? Explain though mapping flow.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the components of workflow manager?
What is difference between a gateway node and worker node?
What are mapplets? How is it different from a Reusable Transformation?
what is SDLC way of code development?
What is workflow? What are the components of workflow manager?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is an expression transformation?
Reusable transformation and shortcut differences
What are the steps involved in the migration from older version to newer version of Informatica Server?
What do you mean by channel change?
What is xml source qualifier transformation in informatica?
What is the use of transformation?