Answer Posted / vikneswaran
in type 1 ... only the latest date... so it is very easy to get
in type 2.. to get by using date or flag or version
in type 3.. to get by selecting previous_column
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
expain about the tune parameters?
How do you load unique records into one target table and duplicate records into a different target table?
Target increases every day even though no new record was inserted
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is pmcmd command?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Why do you use Mapping Parameter and mapping variable?
Explain the different lookup methods used in informatica?
Is it possible to create multiple domains on a single Informatica server?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
can you please explain me pre session and post session options?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain pushdown optimization and types in informatica
What is the format of informatica objects in a repository?
Explain about cumulative Sum or moving sum?