how to load only the first and last record of a flat file
into the target?
Answer Posted / ysr
using Aggregator trans FIRST and LAST funtions we can pass
first and last record
| Is This Answer Correct ? | 21 Yes | 9 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What do you mean by enterprise data warehousing?
What is the difference between source qualifier transformations source filter to filter transformation?
What is mapplet in informatica?
What if the source is a flat-file?
What are the different types of olap? Give an example?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is exclusive and normal mode for repository services?
What are pre and post-session shell commands?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Is stop and abort are same in informatica?
what is Active lock explain
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
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