How to load only the first and last record of a flat file into
the target?
Answer Posted / spandita
After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is lookup transformation?
Differentiate between a database and data warehouse?
How to start a workflow using pmcmd command?
How we can create indexes after completing the load process?
Under what condition selecting sorted input in aggregator may fail the session?
What is update strategy transform?
What is the status code in stored procedure transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Enlist the various types of transformations.
What is an unconnected transformation?
What can we do to improve the performance of informatica aggregator transformation?
Explain constraint based loading in informatica
How do you update the records with or without using update strategy?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
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