How to load last 10 records of flat file in to the target?

Answer Posted / koti

sequence generator, rank transformation.. in rank
transformation write the condition 20 ranks, bottom to top..

Is This Answer Correct ?    11 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can we find the throughput option in informatica?

600


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1509


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2067


How big was your fact table

1318


Which files are created during the session rums by informatics server?

709






How can you differentiate between powercenter and power map?

623


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6475


How to create Target definition for flat files?

754


what is Active lock explain

2369


What are active transformations.

1188


Enlist the advantages of informatica.

632


Performance tuning in UNIX for informatica mappings?

2143


Is there any target staging area in informatica not staging area

2126


What could be the possible resons of locks by user?

665


Explain the scenario which compels informatica server to reject files?

656