we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
- 8 Answers
- 10092 Views
- I also Faced
- E-Mail Answers
Answer Posted / lvpr
Another way is to use rank t/r and load data to target by
filtering 2 and 5 rows.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
what is Active lock explain
What is the scenario which compels informatica server to reject files?
What is persistent lookup cache?
How to create Target definition for flat files?
What is DR strategy for Informatica project?
In informatics server which files are created during the session rums?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
how to load rows into fact table in data warehouse
What is resilience time?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the difference between stop and abort in informatica
Explain how to import oracle sequence into informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What do you mean incremental aggregation?
Can you generate sequence numbers without using the sequence generator transformation?
