Hi,
I have one flatfile as target in a mapping . When i am
trying to load data second time into it.
The records already is in flatfile is getting override. I
don't want to override existing records.
Note : we can do this by implementing CDC / Incremental pool
logic if target is relational .
But this is flatfile. So, even i use this same technique it
will override only
So what is the solution ?
Is there any option at session level for flatfile target ?
Advance Thanks
Answer Posted / krish
there is an option like APPEND IF EXISTS in session
properties
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How can we use batches?
Differences between version 7.x and 8.x.
How many transformations can be used in mapplets.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the informatica workflow?
how we can load rejected record's at run time?(not through bad files)
What are the types of schemas we have in data warehouse and what are the difference between them?
How to create the source and target database connections in server manager?
What are the performance considerations when working with aggregator transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Can we create two repositories on same database instance in oracle?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Tell me about MD5 functions in informatica