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?
Answer Posted / srikanth
target update over ride..
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Define mapplet?
Clarify the utilization of aggregator cache record?
Which development components of informatica have the highest usage?
Enlist few areas or real-time situations where informatica is required.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the tasks that can be performed using sq?
Name the different lookup cache(s)?
What is incremental aggregation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the format of informatica objects in a repository?
How to open an older version of an object in the workspace?
draw informatica architecture 8.6 ?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?