how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answer Posted / sivananda reddy
In informatica use this mapping
source->sqr->aggr->router->exp->target1
|
|->exp->target2
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What do you mean incremental aggregation?
Write the program through which the records can be updated?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain sessions. Explain how batches are used to combine executions?
What is meant by lookup transformation? Explain the types of lookup transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can we handle two sessions in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is a repository? And how to add it in an informatica client?
explan ur project architecture?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What do you understand by term role-playing dimension?