i have a session which creates a file every time when i runs
the session, but it replaces the first file with second file,i
want to append the second file follwed by first file when i
runs the session,how to achieve this?
Answer / priyank
select the option "append if exists" in the session
properties.
Is This Answer Correct ? | 3 Yes | 0 No |
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
How many ways are there to do 'remove duplicate records in informatica'?
can we override a native sql query within informatica? How do we do it?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
in what type of scenario bulk loading and normal loading we use?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Can we update the data in flat file using update strategy?