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
- 9112 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / balu
sourcce --> source qualifier--> sequence generator--
>expression trns-->target
generate sequence for the source data after that in
expression transformation use min and max function on
sequece then connect to target.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / 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 |
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
we have to use order by,where,having we to implement sql query
What are the data movement modes in informatica?
how can import the data from the flat files?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
why we use materialized view over view?
What are the prerequisite tasks to achieve the session partition?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
What is a joiner transformation?
What is the Hierarchy of DWH?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Teradata 
