how to get the only updated records in the target
Answers were Sorted based on User's Feedback
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
what is lookupoverriding?
In which circumstances that informatica server creates Reject files?
If u r using dynamic cache lookup port will be thier in thet which option u will select
performance wise which one is better in joiner and lookup transformation
Why update strategy and union transformations are active?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
write a query to retrieve the latest records from the table sorted by version(scd)
What are Dimensional table?
how to join two flat files in informatica?
If the records doesnt satisfy the filter condition where will it go?
What are the tasks that can be performed using sq?