how to load only the first and last record of a flat file
into the target?
Answer Posted / bsgsr
first record can be loaded using the top and only one rank
in ranker transformation.
the last record using aggregator without group by option.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
can u give example for factless fact table
Enlist few areas or real-time situations where informatica is required.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What do you understand by term role-playing dimension?
How do you change a non-reusable transformation to reusable transformation?
Differences between version 7.x and 8.x.
Differentiate between router and filter transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the sql query overwrite in source qualifier in informatica
What is a snowflake schema?
What are the mapping parameters and mapping variables?
What are the different components of powercenter?
Is it possible to define a single node as a Gateway node as well as worker node?
can anyone explain me about retail domain project in informatica?
What is different between the data warehouse and data mart?