suppose i have source
101 a
101 b
101 c
101 d i want target like 101 abcd how will u achive this
please give me the answer
Answer Posted / prabodh
S-->SQ-->SORTER-->EXP-->AGG-->TARGET
Sort on the firt port,in exp check prev and curr value by
using var ports,if same concat them ,u will get
101 a
101 a b
101 a b c
101 a b c d
from the Exp trans ,group by first port in the Agg trans ,u
will get last row i.e 101 a b c d.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Have you worked with/created Parameter file
What are data-driven sessions?
lookup transformation with screenshots
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to create a non-reusable instance of reusable transformations?
What is main use of mapplet?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Briefly describe lookup transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is meant by pre and post session shell command?
how many types of dimensions are available in informatica?