sorce is a flatfile only 1st and last row should insert to
target how will u do?
Answer Posted / mike
well If your source is a flatfile and you are loading it in
to relational database or a flat file again, then you can
use union transformation to insert the first and last row
correct me if i was wrong
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What do you understand by a term domain?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the types of schemas we have in data warehouse and what are the difference between them?
What is lookup transformation?
what is the Default Source Option For Update Strategy Transformation?
Explain the code page compatibility?
What is target designer and target load order?
What is the difference between Active and Passive transformation?
Does an informatica transformation support only aggregate expressions?
How to extract the informatica rejected data?
how to load dimension table and fact table. plz tell me the steps.
What is the use of code page?
How many ways are there to create ports?
What could be the possible resons of locks by user?
Enterprise data warehouse your projects phase by phase explain?