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
- 9048 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 |
How would you copy the content of one repository to another repository?
what is mean by grouping of condition column in lookup transformation?
one source to target loading insert new rows and update existing rows?
What is diff joiner and lookup
in which situations do u go for starflake schema ?
What will be the approach?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
what is data driven?
Can anyone please distinguish what is Inner join and Outer join
How will you display "Mr" for male & "Mrs" for female in target table?
what is incremental data aggregation?
How do you use reject loader.
Teradata 
