What is a passive transformation?
No Answer is Posted For this Question
Be the First to Post Answer
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 are Target Options on the Servers?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
sorce is a flatfile only 1st and last row should insert to target how will u do?
What do think which one is the better joiner or look up?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to elaborate tracing level?
can we override a native sql query within informatica? Where do we do it? How do we do it?
in static and dynamic which one is better
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .