Interested to Buy Any Domain ? << Click Here >> for more details...
Update strategy transformation is an active
transformation.How it changes the number of records that
pass through it? Please explain....
- 2 Answers
- 21093 Views
- I also Faced
- E-Mail Answers
Answer Posted / jaimeen shah
You can configure the Update Strategy transformation to
either pass rejected rows to the next
transformation or drop them based on the update strategy
expression. By default, the PowerCenter Server forwards
rejected rows to the next transformation. The PowerCenter
Server flags the rows for reject and writes them to
the session reject file. If you do not select Forward
Rejected Rows, the PowerCenter Server
drops rejected rows and writes them to the session log file.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
What is a mapplet/worklet in informatica?
How do you migrate data from one environment to another?
Describe expression transformation?
Under which circumstances, informatica server creates reject files?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Implementation methodology
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 the difference between stop and abort in informatica
Partition, what happens if the specified key range is shorter and longer
how many types of dimensions are available in informatica?
What is mapping debugger?
COM components can be used in Informatica
Design a mapping to load a target table with the following values from the above source?
