how to load only the first and last record of a flat file
into the target?
Answer Posted / tilak
use sequence generator , pass values only with max and min
sequence number filter to target
Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
What is a dimensional model?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
permutations of mapplet
What does update strategy mean, and what are the different option of it?
Difference between Target-based loading and constraint-based loading?
What are the main features of Oracle 8i with context to datawarehouse?
What is the difference between informatica 7.0 and 8.0?
What differs when we choose the sorted input for aggregator transformation?
What is the way to execute pl/sql script using informatica mapping?
I have a flat file, want to reverse the contents of the flat file
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How to use procedural logic inside infromatica?
what are 3 tech challenges/ common issues you face?