sorce is a flatfile only 1st and last row should insert to
target how will u do?
Answer Posted / mike
well If your source is a flatfile and you are loading it in
to relational database or a flat file again, then you can
use union transformation to insert the first and last row
correct me if i was wrong
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Is it possible to define a single node as a Gateway node as well as worker node?
How many ways a relational source definition can be updated and what are they?
Informatica Checkpoints
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is event and what are the tasks related to it?
What is the function of look up transformation?
Explain the difference between mapping parameter and mapping variable?
In how many ways we can create ports?
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?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the tasks that can be performed using sq?
Different circumstance which drives informatica server to expel records?
What are the tasks that source qualifier perform?