How can you recognise whether or not the newly added rows in
the source r gets insert in the target ?
Answers were Sorted based on User's Feedback
Answer / swetha
In the Type2 maping we have three options to recognise the
newly added rows
Version number
Flagvalue
Effective date Range
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / atiric software(raja)
by flag value we can identify the newly inserted rows
| Is This Answer Correct ? | 1 Yes | 0 No |
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
what is bridge tables in informatica
How to fix the etl bugs..Tell me the process?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What is the difference between Bulk Load and Normal Load
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Write the different tools in the workflow manager?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
r u done any partitions in ur project?