sorce is a flatfile only 1st and last row should insert to
target how will u do?
- 2 Answers
- 7860 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is decode in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How are the sources and targets definitions imported in informatica designer?
Explain pmcmd command usage in informatica
Describe data concatenation?
What are the measure objects?
How can we use mapping variables in informatica?
What is the format of informatica objects in a repository?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
explain about unit testing? in real time?
How to load data in informatica ?
How to convert multiple rows to single row (multiple columns) in informatica
What is the cumulative sum and moving sum?
Explain the use of aggregator cache file?
