i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / chandrasekar
Hi Rakesh,
Please go through the above question because don't sort the
records what have the source as it is to load the records
for first and last.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the surrogate key?
What are the guidelines to be followed while using union transformation?
explain abt ur project architecture?
Mention a few design and development best practices for informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the mapping parameters and mapping variables?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
where to store informatica rejected data? How to extract the informatica rejected data?
How to generate or load values in to the target table based on a column value using informatica etl tool.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain the difference between a data warehouse and a data mart?
What is informatica?
What is data movement mode in Informatica and difference between them?
Explain what are the different types of transformation available in informatica.
What is a transaction control transformation?