Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30554 Views
- CTS, I also Faced
- E-Mail Answers
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
what is the size of your data warehousing?
What is a stored procedure transformation?
How to delete duplicate row using informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the use of transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How will the document be delivered to me?
What will be the approach?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is meant by query override?
Explain pushdown optimization and types in informatica
Explain why we use partitioning the session in informatica?
What are the differences between oltp and olap?
Explain what are the different types of transformation available in informatica.
