Interested to Buy Any Domain ? << Click Here >> for more details...
sorce is a flatfile only 1st and last row should insert to
target how will u do?
- 2 Answers
- 9051 Views
- HCL, I also Faced
- E-Mail Answers
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
r u done any partitions in ur project?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is a node in Informatica?
where to store informatica rejected data?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is source qualifier transformation in informatica?
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 are the new features of informatica 9.x in developer level?
Explain the different kinds of facts.
Explain the types of lookup transformation?
What is an expression transformation?
How to create or import flat file definition in to the warehouse designer?
What are the different versions of informatica?
