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
How to load last n records of file into target table - informatica
What is data caches/ index caches?
Reusable transformation and shortcut differences
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 is difference between a gateway node and worker node?
What is joiner transformation?
What is a difference between complete, stop and abort?
How to load a Dimension ? and how to load a fact table?
I have a flat file, want to reverse the contents of the flat file
What is meant by pre and post session shell command?
What do you mean by blocking transformation?
Explain the types of lookup transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Informatica settings are available in which file?
Differentiate between Load Manager and DTM?