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
- 21355 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kondareddy
for example take one condition in update strategy
source we have 20 records. in that records we have 4 records has less then 500 salary
in update strategy condition is
iif(sal<500,3,sal) based on that condition only 15 records stored into target. so it will be effected on rows. becoz in update strategy 3 indicates rejected records....
so it is active....
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the components of Informatica? And what is the purpose of each?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
What do you mean by filter transformation?
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?
What is source qualifier transformation in informatica?
can we override a native sql query within informatica? How do we do it?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the difference between mapping parameter and mapping variable?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
While migrating the data from one environment to another environment how would you manage the connections?
What is complex mapping?
Teradata 
