how to load only the first and last record of a flat file
into the target?
Answer Posted / bsgsr
first record can be loaded using the top and only one rank
in ranker transformation.
the last record using aggregator without group by option.
Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a filter transformation?
Parameter and variable differences
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the modules in Power Center
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
Define sessions in informatica etl?
what is the complex transformation you used in informatica
What is standalone command task?
What is the meaning of decode in informatica?
Which transformation should we use to normalise the COBOL and relational sources?
What is Session and Batches?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to generate sequence numbers using expression transformation?
What are the designer tools for creating transformations?