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?
No Answer is Posted For this Question
Be the First to Post Answer
I want load the data into target with out 1st and last record.
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Design a mapping to load a target table with the following values from the above source?
What are the joiner caches?
what are the row and column separations in Flat Files
what we require for D.modelling?
What are Target Options on the Servers?
what is the main advantage of unconnected lookup
What is the target load order?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
What are the steps involved in the migration from older version to newer version of Informatica Server?
how remove 1st 3 records & last 3 records in informatics